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"
Graduate Sociology Study Material Category: Academic Writing, Content Development, Content Writing, Editing, Educational Research, Ghostwriting, Research, Research Writing Budget: ₹12500 - ₹37500 INR
31-Jan-2026 10:53 GMT
Modern Minimalist Balinese Villa Design Category: 3D Modelling, 3D Rendering, 3D Visualization, Architecture, Building Architecture, Building Design, Graphic Design, Interior Design Budget: $1500 - $3000 USD
ACL Injury Recovery Video Category: Audio Editing, Audio Services, Sound Design, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Voice Over Budget: £20 - £250 GBP
31-Jan-2026 10:50 GMT
Convert DASH to HLS & RTMP Category: JavaScript, Linux, Nginx, Shell Script, Video Processing, Video Streaming Budget: $30 - $250 USD
31-Jan-2026 10:50 GMT
Part-Time Sysadmin Using AI Category: AI Consulting, AI Development, AI Model Integration, AI Text To Speech, Cisco, Computer Security, Internet Security, Linux, Network Monitoring, System Administration Budget: $250 - $750 USD