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"
Web Health Platform UI/UX Design Category: Data Visualization, Figma, Graphic Design, HTML, UI / User Interface, User Interface / IA, UX / User Experience, Web Design, Web Development Budget: £250 - £750 GBP
27-Oct-2025 11:00 GMT
Modern Sleek Product Landing Page Category: Analytics, Graphic Design, HTML, PHP, SEO, Web Design, Web Development Budget: $50 - $100 AUD
27-Oct-2025 10:59 GMT
Agentic AI Lead Insights Category: BeautifulSoup, LangChain, Natural Language Processing, PHP, Python, Research, Web Scraping, Web Search Budget: ₹12500 - ₹37500 INR
We are hiring a Part-Time accountant Category: Accounting, Bank Reconciliation, Bookkeeping, Compliance, Data Analysis, Excel, Finance, Financial Analysis, Intuit QuickBooks Budget: ₹5000 - ₹20000 INR
27-Oct-2025 10:54 GMT
Courier Platform: Website & Apps Category: Android, Android App Development, API Development, App Store Optimization, Database Management, IOS Development, IPhone, Mobile App Development, Payment Processing, Web Development Budget: $2 - $8 USD