blacklabel
Board Regular
- Joined
- Aug 30, 2006
- Messages
- 144
I have an employee stat sheet that I created for my department. It's set up that each row is a specific day. The days start at B4 and ends at AG37. This would be an example of the June 2008 stat sheet. What I'm trying to do is automatically lock the previous data when a new day starts so nothing can be altered without a password that only I and their manager will have. Let me give you an example:
B4:AG4 = June 1st
B5:AG5 = June 2nd
B6:AG6 = June 3rd
For an example let's say today is June 3rd. I need rows B4:AG5 to be locked. But on June 4th, I need B4:AG6 to be locked. I'm trying to automate this so I don't have to change it every day.
Is this possible?
Thanks in advance.
B4:AG4 = June 1st
B5:AG5 = June 2nd
B6:AG6 = June 3rd
For an example let's say today is June 3rd. I need rows B4:AG5 to be locked. But on June 4th, I need B4:AG6 to be locked. I'm trying to automate this so I don't have to change it every day.
Is this possible?
Thanks in advance.