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"
ANSYS Structural Component Analysis Category: 3D CAD, 3D Design, 3D Modelling, Engineering, Finite Element Analysis, Mechanical Engineering, Solidworks, Structural Engineering Budget: €30 - €250 EUR
11 Mar 2026 16:58 GMT
Commission-Based Website Sales Partner Category: Digital Marketing, Internet Marketing, Lead Generation, Linkedin, Sales, Technology Sales Budget: $100 - $10000 USD
11 Mar 2026 16:58 GMT
Modern Icon-Text Logo Design Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design Budget: ₹600 - ₹1500 INR
11 Mar 2026 16:57 GMT
Modern Industrial Office Design Category: 3D Rendering, 3D Visualization, AutoCAD, Building Design, Design Thinking, Furniture Design, Home Design, Interior Design Budget: $25 - $50 USD
11 Mar 2026 16:57 GMT
Startup Grant for Auto Repair Service Category: Business Analysis, Business Consulting, Business Plan Writing, Business Plans, Business Writing, Entrepreneurship, Grant Writing, Market Research Budget: $250 - $750 USD
