itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 115
- Office Version
- 2021
- Platform
- Windows
- MacOS
I have a spreadsheet with days of the week as the header for each column.
What I would like to do is use the last column (7th column) for current information. The seventh column will always be the current date - the other 6 columns will be the previous days.
The next day I would like for all data move over to the left and the oldest day roll off the form. So, the current 7 days will always be on the form.
Is there an easy formula to move everything over each day. I was thinking to use a button with VBA code, unless there is an easier way.
Thanks for the help.
What I would like to do is use the last column (7th column) for current information. The seventh column will always be the current date - the other 6 columns will be the previous days.
The next day I would like for all data move over to the left and the oldest day roll off the form. So, the current 7 days will always be on the form.
Is there an easy formula to move everything over each day. I was thinking to use a button with VBA code, unless there is an easier way.
Thanks for the help.