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"
Complete Marketing Portal Image Download Category: API Integration, Data Extraction, Data Management, Graphic Design, HTML, PHP, Web Scraping, Web Design Budget: $10 - $50 USD
Christian Book Post Scheduler Category: Analytics, Content Creation, Content Marketing, Digital Marketing, Facebook Marketing, Graphic Design, Social Media Management, Twitter Marketing Budget: $30 - $250 USD
28-Feb-2026 16:58 GMT
Vietnamese Virtual Assistant for Operations Category: Admin Support, Customer Service, Data Entry, Email Handling, English Translation, Excel, Google Sheets, Vietnamese Translator, Virtual Assistant, Web Search Budget: $2 - $8 CAD
28-Feb-2026 16:56 GMT
Rencana Online Shop Fashion Remaja Category: Advertising, Branding, Content Creation, Email Marketing, Influencer Marketing, Logo Design, Market Research, Social Media Marketing, Startup Consulting, Web Design Budget: $750 - $1500 USD
28-Feb-2026 16:55 GMT
Retail Fitness Studio Redesign Category: Architecture, Building Design, Building Engineering, Construction Management, Floor Plan, Graphic Design, Interior Design, Logo Design, User Interface / IA, Web Design Budget: $30 - $250 USD
28-Feb-2026 16:54 GMT
Deskripsi Laporan Keuangan Akurat Category: Accounting, Business Analysis, Business Consulting, Business Writing, Data Analysis, Financial Analysis, Financial Consulting, Report Writing Budget: $250 - $750 USD
28-Feb-2026 16:51 GMT
Goethe A2/B1 Writing Videos Category: Content Creation, Education & Tutoring, German Tutoring, Instructional Design, Online Writing, Teaching / Lecturing, Video Editing, Video Production Budget: ₹1500 - ₹12500 INR
28-Feb-2026 16:51 GMT
Fast-Paced Reels Editing Category: Adobe Premiere Pro, Audio Editing, Color Grading, Final Cut Pro, Sound Design, Video Editing, Video Post Editing, Video Production, Video Services, Visual Effects Budget: ₹600 - ₹1500 INR