Hey everyone,
Here’s the situation. I have 30 different sheets, where each sheet represents a specific day of the month—so Sheet1 is the 1st, Sheet2 is the 2nd, and so on.
The structure is identical across all of them. One cell contains the day of the week, like Monday, Tuesday, Wednesday, etc.
What I need is automation. If I enter "Monday" in Sheet1, I want the subsequent sheets to automatically populate with Tuesday, Wednesday, Thursday, and so forth.
In other words, if I set the first day as Tuesday, the second should show Wednesday, the third should be Thursday, and so on.
🙂
Here’s the situation. I have 30 different sheets, where each sheet represents a specific day of the month—so Sheet1 is the 1st, Sheet2 is the 2nd, and so on.
The structure is identical across all of them. One cell contains the day of the week, like Monday, Tuesday, Wednesday, etc.
What I need is automation. If I enter "Monday" in Sheet1, I want the subsequent sheets to automatically populate with Tuesday, Wednesday, Thursday, and so forth.
In other words, if I set the first day as Tuesday, the second should show Wednesday, the third should be Thursday, and so on.
🙂