I need a google sheets expert (or advanced level) to perform a few modifications that I do not know how to do on my workbook. Basically just the following
To do on this sheet:
1. Create a script to Protect all highlighted areas
2. Button to erase all data on unhighlighted area. To be placed on "totals" sheet
3. Disregard last sheet "Kitchen Checker"
4. Sum up data on per day for cells A3 to A84 per day (MonAM + MonPM + TueAM....) on the Totals sheet
5. Create a 2nd exact workbook copy with similar protections but change Row highlighted cells formula from MonAM to 2MonAM, from MonPM to 2MonPM....
I think it is fairly simple but I do not know how to do this so i am seeking help.
9 pekerja bebas membida secara purata $42 untuk pekerjaan ini