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"
Multi-Vendor Shopify Marketplace Development Category: ECommerce, Shopify, Shopify Development, Shopify Templates, Web Application, Web Design, Web Development Budget: ₹12500 - ₹37500 INR
07-Dec-2025 11:00 GMT
On-Page SEO Enhancement Category: Content Strategy, Content Writing, Digital Marketing, HTML, Internet Marketing, Keyword Research, Link Building, SEO, Website Optimization, WordPress Budget: $30 - $100 USD
07-Dec-2025 10:59 GMT
Instant Backlink Indexing Tool Category: API, Desktop Application, Google Webmaster Tools, JavaScript, Node.js, Python, Web API, Web Crawling, Web Development, Web Search Budget: ₹12500 - ₹37500 INR
07-Dec-2025 10:58 GMT
Beginner-Friendly Email Marketing Campaign Category: A / B Testing, Analytics, Content Writing, Copywriting, Digital Marketing, Email Marketing, Mailchimp, Marketing Strategy Budget: $15 - $25 USD