a) I want to paste Raw client data into tab " Raw Data" in excel
b) However I want the data automatically - when I flip over to the "Auto_Filtered_ClientData" tab to auto filter data i dont need to exclude eveything under a specific value ( in this case under 5) but to include Blanks and "-"
C) once fitlered I also need it to sort it from Largest to Smallest in the Amount column of the Auto Filtered CLient data tab
d) Any value in the amount column of "Auto_Filtered_ClientData" tab that has "-" or "#NA" this needs to be replaced with a zero "0".
e) The Settings Tab - should be able to adjust values NOT to include each time ( so this can be adjusted in the future).
I want to avoid Macro buttons , and VBA as much as possible (if at all?) - I just want to dump the raw data and then see the results populate automatically in the second tab "Auto_Filtered_ClientData"
Wix SEO Specialist for One-Time Project Category: Internet Marketing, Keyword Research, Marketing, SEO, SEO Auditing, Web Development, Website Management, Website Optimization, White Hat SEO, Wix Budget: £10 - £250 GBP
11-Feb-2026 11:03 GMT
Humorous Italian E-Commerce Reviews Category: Blog Writing, Content Marketing, Content Writing, Copywriting, Creative Writing, Digital Marketing, SEO Budget: $10 - $30 USD
11-Feb-2026 11:03 GMT
Gold M1 Heikin Ashi Indicator Category: Backtesting, Data Visualization, Financial Analysis, JavaScript, Market Research, Metatrader, PHP, Pine Script, Signal Processing, Software Architecture Budget: $250 - $750 USD
Relocate Logic Pro Plugins Category: Audio Engineering, Audio Production, C, Programming, C++, Music Production, Objective C, System Administration Budget: ₹600 - ₹1500 INR
11-Feb-2026 11:02 GMT
GC with TCD/FID for Hydrocarbons Category: Chemical Engineering, Data Analysis, Electronics, Engineering, Instrumentation, Research And Development, Signal Processing Budget: ₹150000 - ₹250000 INR
11-Feb-2026 11:02 GMT
UniFi Identity Migration for Network Access Category: Active Directory, Documentation, Microsoft Exchange, Network Administration, Network Engineering, Ubiquiti, VPN, Windows Server Budget: ₹400 - ₹750 INR