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"
Asisten Penjadwal Google Calendar Category: Admin Support, Data Entry, Event Planning, Excel, HTML, PHP, Project Management, Time Management Budget: $30 - $250 USD
24-Apr-2026 09:58 GMT
High-Res Logo Suite Creation Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: £20 - £250 GBP
24-Apr-2026 09:57 GMT
Web Code Validation Category: CSS, CSS3, Frontend Development, HTML, HTML5, JavaScript, PHP, Web Development Budget: £250 - £750 GBP
24-Apr-2026 09:57 GMT
N8N Order Quote Automation Category: API Integration, Docker, Excel, HTML, JavaScript, N8n, Vue.js, Web Development Budget: $250 - $750 USD
24-Apr-2026 09:54 GMT
AI Customer Support Chatbot Builder Category: AI Chatbot Development, AI Development, API Integration, HTML, Java, JavaScript, Natural Language Processing, PHP Budget: $250 - $750 USD
3D Promotional Motion Graphics Edit Category: 3D Animation, 3D Graphic Design, 3D Rendering, After Effects, Animation, Motion Graphics, Sound Design, Video Editing Budget: £18 - £36 GBP
UK Business Dispute Legal Assistance Needed Category: Contracts, Corporate Law, Employment Law, Legal, Legal Analysis, Legal Assistance, Legal Research, Litigation Budget: min £36 GBP
24-Apr-2026 09:43 GMT
Comprehensive Building Design Review Category: 3D Design, 3D Modelling, 3D Rendering, Architectural Engineering, AutoCAD, Building Architecture, Building Design, Home Design, Interior Design, Revit Budget: $250 - $750 USD
