HaudYerWeesht
New Member
- Joined
- Jun 9, 2016
- Messages
- 17
- Office Version
- 2016
- Platform
- Windows
If I'm on week 1 and I have a column titled Week 1 that shows totals of other columns in week 1 is there a way when I open the spreadsheet next week that the same column will automatically update to Week 2 and show the totals of the week 2 columns?
Basically I have a spreadsheet of employees hours available and I've been asked to add a 6 week forecast so I've got 6 columns titled the week number we're on now and the next 5 weeks but was wondering if I opened the spreadsheet next week if excel is capable of moving next week to the first column and then changing the other 5 columns to the next 5 weeks.
I hope this makes sense and thanks for any help
Basically I have a spreadsheet of employees hours available and I've been asked to add a 6 week forecast so I've got 6 columns titled the week number we're on now and the next 5 weeks but was wondering if I opened the spreadsheet next week if excel is capable of moving next week to the first column and then changing the other 5 columns to the next 5 weeks.
I hope this makes sense and thanks for any help
