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"
Modern Minimalist Logo Design for Brand Identity Category: Adobe Illustrator, Photoshop, Branding, Creative Design, Graphic Design, Illustration, Logo Design, Typography, Visual Design Budget: ₹1500 - ₹12500 INR
09-Feb-2026 05:00 GMT
Corporate Wix Site Revamp Category: Graphic Design, HTML, UI / User Interface, User Interface / IA, UX / User Experience, Web Design, Web Development, Website Optimization, Wix Budget: ₹1500 - ₹12500 INR
09-Feb-2026 04:58 GMT
Virtual Payment Assistance on Web Category: API, Backend Development, Google Sheets, Virtual Assistant, VPN, Web Scraping Budget: €250 - €750 EUR
09-Feb-2026 04:58 GMT
Legal Explainer Video Editor Category: A / V Editing, Adobe Premiere Pro, Animation, Final Cut Pro, Graphic Design, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 AUD
09-Feb-2026 04:58 GMT
One-Page PDF Replica Needed Category: Adobe Acrobat, Adobe Creative Cloud, Adobe Illustrator, Adobe InDesign, Graphic Design, Illustration, Microsoft Word, PDF, Print Design, Visual Design Budget: $10 - $30 CAD
09-Feb-2026 04:57 GMT
Minimalistic Artist Portfolio Site Category: CSS, Graphic Design, HTML, JavaScript, PHP, Web Development, Web Design Budget: $250 - $750 USD
09-Feb-2026 04:57 GMT
Type Handwritten Notes with Symbols Category: Copy Typing, Editing, Microsoft Word, PDF, Proofreading, Technical Writing, Transcription, Word Budget: $25 - $50 USD
