Forum Discussion
Reference cell in previous sheet
How do I reference the value of a cell in a previous sheet without having to name it? I have tried the SHEETOFFSET formula, and it doesn't work on my .xlsm workbook. I am trying to pull in number of...
What is the issue with ='previoussheet'!,J23 method - If it's not working try ='previoussheet'!J23
Alternatively, type '=' in the cell where you want the linked value, then click on the previoussheet tab and select the cell with the required value and hit enter.
I hope this is helpful.
Thank you (five years later). The Alternative worked for me.
However, it would have been nice if previoussheet worked too but it seemed to interpret previoussheet as a file name.