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"
College Essay Assistance -- 2 Category: Academic Writing, Article Writing, Content Writing, English (US) Translator, Essay Writing, Ghostwriting, Proofreading, Report Writing, Research Writing, Writing Budget: $30 - $250 USD
26-Aug-2025 03:56 GMT
Convert JAR to a Webapp Category: Backend Development, Database Design, Frontend Development, J2EE, Java, JavaScript, JSP, Web Development Budget: $30 - $250 USD
Catalan to English, Spanish and French (Long term) Category: Catalan Translator, English (US) Translator, French Translator, Spanish Translator, Translation Budget: $20 Deadline: Asap (Budget: $8 - $15 AUD
26-Aug-2025 03:53 GMT
Niche Discovery: Amazon Keyword Research Category: Amazon, Data Analysis, Data Mining, Internet Marketing, Keyword Research, Link Building, Market Research, Product Research, Research, SEO Budget: $30 - $250 USD
26-Aug-2025 03:52 GMT
Daily Financial Analysis Dashboard Category: Data Analysis, Data Processing, Data Visualization, Excel, Excel Macros, Financial Analysis, Microsoft Access, Visual Basic Budget: ₹750 - ₹1250 INR