https://docs.google.com/spreadsheets/d/10wT1xopLKYn8kptHByDGav-fDBkhehq2HcRwkLhaJr0/edit?usp=sharing
I need a simple script to be written where the January Row will be locked at the 1st of Febuary and so on till December where it will lock the next year January the 1st.
I did this cause not every month has a 31st but every month has a 1st.
Its a rather simple and intuitive script but, I don’t have the knowledge to write the script. If someone can write it or teach me the abc’s to writing it so that I can understand the script, I would appreciate it.
I shared a doc link to my google sheet so you have an idea of what I am looking for and envisioning.
- I want cells B12:F12 to lock on the first of Febuary. (Yellow cells) The greyed out cells are locked no matter what so that does not have to be changed.
- The comment section or (cells in white) can be unlocked indefinetely and doesn’t need to be changed.
Summary: In my google sheet I need the (yellow cells) locked on a monthly basis based on the first of every month. January’s cells B12:F12 locked on Febuary 1st, Febuary’s cells B13:F13 locked on March 1st and so on till December where it locks on January 1st of next year.
Thank You for reading this and your time.