I have a worksheet that contains the days of the week (Mon, Tues, etc...) in B4:B10. In C4:G10 these cells = a cell on other sheets.
Each week I have to go in and manually change each cell reference to look at the next row down on the sheet they pull from. Is there a way that I can set it so that when I push a command button, it will just increment the cell reference row by one?
Example: C4 is ='3rd'!B23
I would like to push a button so that C4 is ='3rd'!B24
Bookmarks