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"
Help me monetize my esports brand Category: Customer Support, Esports, Event Planning, Instagram Marketing, Media And Entertainment Tax, Sales, TikTok Budget: $30 - $250 USD
02-Feb-2026 23:04 GMT
Sharepoint Workflow and Data Automation -- 2 Category: Business Analysis, Excel, Microsoft 365, Power Automate, PowerApps, Sharepoint, UX / User Experience, Wireframes, Workflow Consulting Budget: ₹1500 - ₹12500 INR
Unique Sled Dog Storybook Category: Book Design, Book Writing, Content Writing, EBooks, Editing, Publishing Budget: $250 - $750 USD
02-Feb-2026 22:56 GMT
Tropical Modern Duplex Design, Guinea, West Africa Category: 2D Drafting, 3D Rendering, 3D Visualization, Architectural Rendering, Architectural Visualization, Architecture, AutoCAD, Building Architecture, Building Design, Interior Design Budget: $30 - $250 USD