Hi,
I have 2 workbooks (01 January.xlsm and Bar Area Taking Print.xlsx)
Initially in 01 January there are sheets called Sheet1, Sheet2,..Sheet5 and Totals.
In the Bar Area Taking Print.xlsx, there are 4 sheets called QTR1, QTR2, QTR3 and QTR4.
In the Bar Area Taking Print.xlsx, cell B4 refers to 01 January, sheet1, cell reference B4.
My problem is that all sheets starting Sheet in 01 January are renamed every year and therefore the reference in Bar Area Taking Print.xlsx doesn’t work, because it refers to Sheet1.
Is there any way that that the reference in Bar Area Taking Print.xlsx can still point to the absolute sheet name of sheet1 in 01 January.xlsm before it was changed?
The current formula in Bar Area Taking Print.xlsx is [01 January.xlsm]03-Jan-21'!$B$4, can the 03-Jan-21 still refer to Sheet1
Any help would be appreciated.
I have 2 workbooks (01 January.xlsm and Bar Area Taking Print.xlsx)
Initially in 01 January there are sheets called Sheet1, Sheet2,..Sheet5 and Totals.
In the Bar Area Taking Print.xlsx, there are 4 sheets called QTR1, QTR2, QTR3 and QTR4.
In the Bar Area Taking Print.xlsx, cell B4 refers to 01 January, sheet1, cell reference B4.
My problem is that all sheets starting Sheet in 01 January are renamed every year and therefore the reference in Bar Area Taking Print.xlsx doesn’t work, because it refers to Sheet1.
Is there any way that that the reference in Bar Area Taking Print.xlsx can still point to the absolute sheet name of sheet1 in 01 January.xlsm before it was changed?
The current formula in Bar Area Taking Print.xlsx is [01 January.xlsm]03-Jan-21'!$B$4, can the 03-Jan-21 still refer to Sheet1
Any help would be appreciated.