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"
Smart Plant App UI/UX Design Category: Accessibility, Design Thinking, Graphic Design, UI / User Interface, Usability Testing, User Experience Research, User Interface / IA, UX / User Experience, Visual Design, Web Design Budget: ₹100 - ₹400 INR
11-Jan-2026 10:59 GMT
Water Treatment Site 3D Animation Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, Animation, Blender Budget: £250 - £750 GBP
11-Jan-2026 10:59 GMT
Verbatim Απομαγνητοφώνηση 15' Βίντεο Category: Academic Writing, Content Writing, Copy Typing, Transcription, Word, Word Processing Budget: €8 - €30 EUR
11-Jan-2026 10:58 GMT
Service-Based E-Commerce Website Category: ECommerce, HTML, Mobile App Development, Payment Gateway Integration, Shopify, Web Development, Web Security, Web Design, WooCommerce, WordPress Budget: €250 - €750 EUR
Full-Stack Meta Social Marketer Category: Content Creation, Conversion Rate Optimization, Copywriting, Digital Marketing, Google Adwords, Google Analytics, Graphic Design, Lead Generation, Social Media Marketing, Video Production Budget: ₹100 - ₹400 INR
11-Jan-2026 10:55 GMT
Retention Email Strategy Specialist Category: A / B Testing, Automation, Customer Retention, Data Analysis, Email Marketing, Klaviyo, Mailchimp, Marketing Strategy Budget: $250 - $750 USD
Web Automated Trading Platform Development Category: API Development, C#, Programming, MySQL, PHP, Security, Software Architecture, Trading, Web Development Budget: ₹37500 - ₹75000 INR