VickyOakman17
New Member
- Joined
- Jan 22, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am trying to find a way in which I can add a new worksheet each month or every two months, to a workbook, and the formulas will automatically update to the previous worksheet.
For example I have a Jan 2023 worksheet but then add March 2023- I want to following formulas if possible to update to the 'Jan 2023' cells not the 'master' cells. Without me having to manually change them.
=SUM(K32-Master!K32) would now need to be =SUM(K32-'Jan 2023'!K32)
Is this possible to do using a macro or VBA.
For example I have a Jan 2023 worksheet but then add March 2023- I want to following formulas if possible to update to the 'Jan 2023' cells not the 'master' cells. Without me having to manually change them.
=SUM(K32-Master!K32) would now need to be =SUM(K32-'Jan 2023'!K32)
Is this possible to do using a macro or VBA.