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"
PrestaShop E-Commerce Store Build Category: CSS, ECommerce, HTML, Payment Gateway Integration, PHP, Prestashop, SEO, Web Development, Web Design, Website Optimization Budget: €1500 - €3000 EUR
12-Feb-2026 11:01 GMT
Optimize OBS Stream & Record Category: Audio Engineering, Video Conferencing, Video Editing, Video Hardware, Video Processing, Video Production, Video Services, Video Streaming Budget: $10 - $30 USD
12-Feb-2026 11:00 GMT
AI Marketing Video Production Category: After Effects, AI (Artificial Intelligence) HW / SW, AI Chatbot Development, AI Content Creation, AI Design, Animation, Video Editing, Video Services Budget: $15 - $25 USD
Manual Tester for Corporate Website Category: Accessibility Testing, Graphic Design, HTML, Test Plan Writing, Test Strategy Writing, User Experience Research, User Interface / IA, Web Design, Website Testing Budget: $250 - $750 USD
