I need a spreadsheet with following sheets: Main, 1, 2, 3, 4, 5, 6. Main will contain the information to be filtered, organized by products. I'll provide a document with the Main information.
Some products will be set to "FALSE", other products to "TRUE". Some rows will have three products set to "TRUE", other just one or all of them. I need to automatically update the other sheets based on the number of product columns with a "TRUE" value on them. This new value for each cell instead of being "TRUE" will be the name of the column it has on the Main sheet.
- Attached you'll find a sample document. Colored in light yellow you'll find the products/columns I'm talking about for Main. You'll also find the other sheets, which will be configured or populated based on the amount of products set to "True" in the Main sheet.
- This video explains visually what I need: [url removed, login to view]
- To apply for this project, please start your application with "Hola". Let me know if you need any clarification.
- This needs to be delivered TODAY, within the following 3 hours.
- I use Google Sheets (not Excel or OpenOffice).
- All the information shared with you is confidential.
24 freelancers are bidding on average $25 for this job
hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.
Hola, Thank for your very detail requirement. With my expertise in Google Script on Google Sheet , I could help you to make it done within 1 hour only. Only paid when it works. Pm me for more detail ! Regards,
""Dear Next Employer I will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started. Thanks""