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"
Lead-Generating Social Media Campaign Category: Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Instagram Marketing, Internet Marketing, Lead Generation, Social Media Marketing Budget: $15 - $25 USD
Italian B2C Data Sourcing Category: Data Analysis, Data Collection, Data Entry, Data Integration, Data Management, Data Mining, Data Processing, Data Visualization, Lead Generation, Leads Budget: €30 - €250 EUR
Lead-Focused Meta Ad Management -- 2 Category: A / B Testing, Advertising, Analytics, Digital Marketing, Google Adwords, Internet Marketing, Lead Generation, Sales Budget: ₹1500 - ₹12500 INR
Virtual Assistant for Residential Construction Category: Admin Support, Construction Management, Customer Service, Invoicing, Project Management, Time Management, Virtual Assistant, VoIP Budget: $2 - $8 USD
17-Feb-2026 16:58 GMT
Support client FR–Chinois multilingue Category: Customer Service, French Translator, Helpdesk, Technical Support, Translation, Web Search, Zendesk Budget: €2 - €6 EUR