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"
Excel Data Specialist for HRA Records Category: Data Analysis, Data Entry, Data Management, Data Mining, Data Modeling, Data Processing, Data Visualization, Excel, Excel Macros, Statistical Analysis Budget: ₹750 - ₹1250 INR
Creazione di Gadget 3D Dettagliato Category: 3D Animation, 3D CAD, 3D Drafting, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization, 3ds Max Budget: €8 - €30 EUR
22-Aug-2025 15:58 GMT
Clinical Research Article Specialist Category: Data Analysis, Medical, Medical Research, Medical Writing, Research, Research Writing, Scientific Writing, Statistical Analysis Budget: £250 - £750 GBP
Social Media Engagement Content Category: Photoshop, Adobe Premiere Pro, Canva, Content Creation, Graphic Design, Social Media Management, Social Media Marketing, Video Editing Budget: $250 - $750 USD
22-Aug-2025 15:58 GMT
Podcast Intro/Outro Video Edit Category: A / V Editing, Animation, Graphic Design, Podcast Editing, Podcast Marketing, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $10 - $30 USD
Circe 3: French to Spanish Category: Data Annotating, French Translator, Spanish Translator, Translation Budget: $8 - $15 USD
22-Aug-2025 15:55 GMT
AI-Powered Business Automation System Category: AI Agents, AI Chatbot Development, AI Development, AI Model Development, Data Entry, Excel, Leads, Sales Budget: ₹12500 - ₹37500 INR