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.