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"
Artikel Ilmiah Emas dan Bauksit -- 2 Category: Academic Writing, Article Writing, Content Writing, Environmental Science, Geology, Research Writing, Scientific Writing, Technical Writing Budget: $10 - $30 USD
23-Feb-2026 23:04 GMT
Cinematic Car Delivery Film Category: Audio Editing, Audio Services, Cinematography, Film Editing, Sound Design, Video Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR
Removable Steel Stop Log with Rubber Seal Category: 3D Design, 3D Modelling, 3D Rendering, CAD / CAM, Manufacturing Design, Mechanical Engineering, Product Design, Prototyping, Structural Engineering, Welding Budget: $250 - $750 USD
23-Feb-2026 23:00 GMT
Medical Centre Owner Research Task Category: Data Analysis, Data Collection, Data Entry, Data Management, Excel, Research, Virtual Assistant, Web Search Budget: $2 - $8 USD
23-Feb-2026 22:57 GMT
DN250 Pipework 3D Modelling & Drawings Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, AutoCAD, Mechanical Engineering, Revit Budget: £250 - £750 GBP
23-Feb-2026 22:56 GMT
Cinematic Car Delivery Video Category: After Effects, Cinematography, Color Grading, Film Editing, Lighting Design, Video Production, Video Services Budget: ₹12500 - ₹37500 INR
23-Feb-2026 22:56 GMT
Realistic Night Urban Cityscape Drawing Category: 2D Drawing, 2D Layout, Caricature & Cartoons, Digital Art, Graphic Design, Illustration, Photoshop Budget: min $50 USD
23-Feb-2026 22:55 GMT
Vendedor Home Office Category: Appointment Setting, B2B Marketing, CRM, Lead Generation, Leads, Sales, Telemarketing, Web Search Budget: $2 - $8 USD