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"
IT Project Intake Category: Business Development, Consulting, CRM, IT Project Management, Lead Generation, Leads, Sales, Software Development, Technical Support, Web Development Budget: ₹600 - ₹1500 INR
13-Feb-2026 11:02 GMT
Founding E-commerce CEO Partner Needed for the US marketplace Category: Business Development, Compliance, Data Scraping, Dropshipping, Financial Planning, Market Research, Marketing Strategy, Project Management, Startup Consulting Budget: $30 - $250 USD
MSME/Startup DPR & Loan Plan Category: Business Analysis, Business Plan Writing, Business Plans, Finance, Financial Analysis, Financial Consulting, Project Management, Startup Consulting Budget: ₹1500 - ₹12500 INR
13-Feb-2026 11:00 GMT
Custom Web E-Commerce Build Category: CSS, Graphic Design, HTML, JavaScript, Laravel, PHP, Web Development, Web Design Budget: $15 - $25 USD
13-Feb-2026 11:00 GMT
Cricket League Promo Video Category: After Effects, Animation, Graphic Design, Motion Graphics, Sound Design, Video Ads, Video Editing, Video Post Editing, Video Services Budget: ₹1500 - ₹12500 INR
13-Feb-2026 10:59 GMT
Full-Stack Wedding Portal Development Category: Amazon Web Services, AngularJS, Django, Full Stack Development, HTML, JavaScript, Mobile App Development, Node.js, React Native, Web Development Budget: $2000 - $6000 HKD
13-Feb-2026 10:59 GMT
IT Project Broker -- 3 Category: Business Development, Consulting, CRM, IT Project Management, Lead Generation, Leads, Sales, Software Development, Technical Support, Web Development Budget: ₹600 - ₹1500 INR
13-Feb-2026 10:58 GMT
ReCAPTCHA v3 Setup Category: API Integration, Google APIs, Google Cloud Platform, JavaScript, PHP, Testing / QA, Web Application Audit, Web Development, Web Security, Website Testing Budget: €8 - €30 EUR
