CordingBags
New Member
- Joined
- Mar 7, 2022
- Messages
- 37
- Office Version
- 2016
- Platform
- Windows
I have a growing workbook, with a MASTER as first sheet.
Each week I copy and rename this master sequentially with the previous sheets in the book.
Thus providing a standardised layout, dates, formulas, formats etc.
Some of the cells in the newly created sheet need to pick up cell references from the previous week.
This I have to do manually. eg sheet 80 cell G23 has the manually entered formula =+'79'!G24.
There are several other cell locations around the sheet that similarly need to reference the preceding sheet.
Whilst this is little more than a chore if I am completing the sheet, it is one more detail to pass on to any deputy.
Is there a formula that could be entered on the MASTER sheet such that when it is copied the new sheet correctly references the preceding.
Many Thanks for any suggestion
Each week I copy and rename this master sequentially with the previous sheets in the book.
Thus providing a standardised layout, dates, formulas, formats etc.
Some of the cells in the newly created sheet need to pick up cell references from the previous week.
This I have to do manually. eg sheet 80 cell G23 has the manually entered formula =+'79'!G24.
There are several other cell locations around the sheet that similarly need to reference the preceding sheet.
Whilst this is little more than a chore if I am completing the sheet, it is one more detail to pass on to any deputy.
Is there a formula that could be entered on the MASTER sheet such that when it is copied the new sheet correctly references the preceding.
Many Thanks for any suggestion