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"
R Script: Align Triplicate Measurements Category: Data Analysis, Data Management, Data Mining, Data Modeling, Data Processing, Data Science, Data Visualization, Predictive Analytics, Statistical Analysis, Statistical Modeling Budget: €30 - €250 EUR
15-Dec-2025 10:53 GMT
Sleek Marketing Title Sequence Category: After Effects, Animation, Graphic Design, Motion Graphics, Storyboard, Typography, Video Editing, Video Production Budget: ₹400 - ₹750 INR
15-Dec-2025 10:52 GMT
WordPress Core Web Vitals 80+ Category: CSS, HTML, Performance Tuning, PHP, Web Application, Web Design, Web Development, Web Security, Website Optimization, WordPress Budget: €30 - €250 EUR
15-Dec-2025 10:52 GMT
Surreal Dreamy Indie Music Video Category: Cinematography, Creative Design, Film Production, Music Video, Video Editing, Video Production, Videography, Visual Effects Budget: £250 - £750 GBP
Restaurant POS Development with Integrated Payments Category: Android, Android App Development, API Development, Backend Development, Database Management, Database Programming, MySQL, PHP, Software Architecture, Software Development Budget: ₹250000 - ₹500000 INR
15-Dec-2025 10:44 GMT
Power BI Procurement Register Category: Business Intelligence, Data Analysis, Data Entry, Data Modeling, Data Processing, Data Visualization, Excel, Power BI, Report Writing, Sharepoint Budget: $8 - $15 AUD
15-Dec-2025 10:44 GMT
Premium D2C website design Category: Corporate Identity, Payment Gateway Integration, SEO, Shopify, Shopify Development, Shopify Templates, Typography, Visual Design, Web Design, Web Development Budget: ₹12500 - ₹37500 INR
15-Dec-2025 10:43 GMT
Especialista en Notion Category: AI Development, API, API Integration, Automation, Excel, Large Language Model, Notion, PHP, Salesforce.com, Software Architecture Budget: €30 - €250 EUR
15-Dec-2025 10:43 GMT
30-Second Mixed-Media Product Promo Category: Adobe Premiere Pro, After Effects, Animation, Color Grading, DaVinci Resolve, Sound Design, Video Editing, Video Services Budget: ₹600 - ₹1500 INR
