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"
WordPress Business Site + Payments Category: HTML, Payment Gateway Integration, PHP, SEO, Web Development, Web Hosting, Web Design, WordPress Budget: $250 - $750 USD
Health & Wellness Blog Writer Needed Category: Article Writing, Blog, Blog Writing, Content Writing, Ghostwriting, Health Care Management, Health Planning, SEO Budget: £250 - £750 GBP
Health Care Mobile App Development Category: Android, Graphic Design, IPhone, Mobile App Development, Mobile Development, UI / User Interface, User Experience Research Budget: ₹1500 - ₹12500 INR
Real Estate Excel Forecasting Model Category: Data Analysis, Data Management, Data Processing, Data Visualization, Excel, Real Estate, Statistical Analysis, Statistics Budget: $30 - $250 USD
16-Feb-2026 16:56 GMT
AI Dev Project Manager Category: AI Agents, AI Chatbot Development, AI Development, Project Management, Python, React.js Budget: €18 - €36 EUR
16-Feb-2026 16:55 GMT
Logo & Thumbnail Design -- 2 Category: Photoshop, Advertising, Branding, Graphic Design, Illustration, Logo Design, Print Design, Typography, Web Design Budget: $10 - $30 USD
