Hi guys, I searched online but there's no solution to this one I could find.

- as per the sheet attached, there are two tabs: DAILY POSTS and SUBMIT.
- cells market in yellow colour are where a user would select/enter data during a week
- all entered data in both tabs should be reset/cleared out automatically at 9am UK TIME every SATURDAY
- original file contains data in other cells as well, none of that data should be touched by a script, just cells marked in yellow
- once one sheet is set, copies of it will be made and shared with a few users, for each person to use it as their own
- even though each user could be in different countries (USA, UK, AU, etc) but all data should still be reset/cleaned up every Saturday for EVERYONE at 9am UK time.

a sheet is attached below, do you know the way, please?

https://docs.google.com/spreadsheets...it?usp=sharing

thanking you in advance.