Feb 10 2022 08:08 PM
I want to carry forward 1 figure on a sheet to the next fortnight sheet. When I copy the sheet to create the next sheet it keeps the same refernce link.
I use ='2022 2 2'!L33
This brings in the figure from previous sheet. But then each time sheet is copied it will only obtain the total from the sheet '2022 2 2'
How can I have it add on to the next sheet to be '2022 2 16' etc
I hope this makes sense.
Thanks
Feb 10 2022 10:46 PM - edited Feb 10 2022 10:47 PM
Hello:
Excel treats sheet names as aliases, that is, sheet names start from Sheet1 to Sheet#? and not like the name displayed in the tab.
The formula to use would be (in your case):
'=ADDRESS(ROW(L33); COLUMN(L33);4;1;" Sheet"&SHEET(L33))'
being:
'SHEET()' gives you the sheet number in which the selected cell is located.
'COLUMN()' gives you the column number of the selected cell.
'ROW()' gives you the row number of the selected cell.
and
'ADDRESS()': creates the address for the cell
See help functions in:
https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d9...
Feb 10 2022 11:03 PM
Feb 10 2022 11:06 PM