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"
Clean and Optimize Financial Excel -- 3 Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Excel VB Capabilities, Financial Analysis, Microsoft, Visual Basic Budget: ₹600 - ₹1500 INR
26-Jan-2026 23:04 GMT
Admin Chat Media Sosial Category: Chatbot, Content Marketing, Customer Service, Digital Marketing, Facebook Marketing, Sales, Social Media Management Budget: $15 - $25 USD
26-Jan-2026 23:03 GMT
Facebook Ads for Global Sales Category: A / B Testing, Advertising, Conversion Rate Optimization, Digital Marketing, Facebook Marketing, Google Adwords, Internet Marketing Budget: €8 - €30 EUR
26-Jan-2026 23:02 GMT
Wellness program Category: Article Writing, Content Writing, Copywriting, Creative Writing, Health, Life Coaching, Personal Development Budget: $30 - $250 AUD
Philippines CDO Music Video Shoot Category: Adobe Premiere Pro, After Effects, Audio Editing, Cinematography, Color Grading, Drone Photography, Final Cut Pro, Video Editing, Video Production, Videography Budget: $30 - $250 AUD