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"
YouTube Productivity Software Explainer Videos Category: Adobe Premiere Pro, After Effects, Camtasia, Explainer Videos, Video Editing, Video Production, Video Services, Videography Budget: ₹600 - ₹1500 INR
05-Feb-2026 23:04 GMT
Management Category: Admin Support, Internet Marketing, Property Management, Social Media Marketing Budget: $250 - $750 USD
05-Feb-2026 23:03 GMT
Modern Phoenix Dachshund Logo Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: $30 - $250 AUD
05-Feb-2026 23:02 GMT
Lovable to WordPress Category: HTML, MySQL, PHP, SEO, SSL, Web Development, Website Management, WordPress Budget: €8 - €30 EUR
05-Feb-2026 23:00 GMT
Business Video Editor/Creator Category: Adobe Premiere Pro, After Effects, Animation, Content Creation, Creative Design, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
WordPress Security Cleanup & SEO Category: Computer Security, Database Management, Internet Security, SEO, Web Security, Website Management, Website Optimization, WordPress Budget: $250 - $750 NZD
05-Feb-2026 22:50 GMT
Traditional 2-3BR SIPs Home Category: Architecture, AutoCAD, Building Architecture, Building Design, Construction, Project Management, Project Scheduling, Structural Engineering Budget: $1500 - $3000 USD
05-Feb-2026 22:50 GMT
Modern Commercial Pool Design Category: AutoCAD, Building Design, CAD / CAM, Construction Management Budget: $15 - $25 USD
05-Feb-2026 22:46 GMT
Asistente Ventas con Llamadas CRM -- 2 Category: CRM, Customer Service, Data Entry, Data Management, ERP, Lead Generation, Odoo, Sales, Sales Management, Software Architecture Budget: €6 - €12 EUR
05-Feb-2026 22:45 GMT
Quick Logo Text Update _TIME SENSITIVE Category: Adobe Illustrator, Photoshop, Business Card Design, Graphic Design, Logo Design, PDF, Word Budget: $10 - $30 USD
