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"
Traditional Kitchen & Furniture Design Category: 3D Design, 3D Modelling, 3D Rendering, Building Design, CAD / CAM, Furniture Design, Graphic Design, Interior Design Budget: £250 - £750 GBP
29-Mar-2026 15:53 GMT
Manual Excel Data Entry -- 3 Category: Data Analysis, Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Visual Basic Budget: ₹100 - ₹400 INR
29-Mar-2026 15:53 GMT
Comprehensive Internet Research Specialist Category: Certified Ethical Hacking, Data Protection, Growth Hacking, Internet Research, Penetration Testing Budget: $30 - $250 USD
29-Mar-2026 15:53 GMT
Podcast Studio Setup Category: Audio Editing, Audio Engineering, Audio Production, Audio Services, Music, Podcasting, Sound Design, Video Production Budget: $30 - $250 USD
