Forum Discussion
Solved
Reference a cell to grab the sheet name for another cell reference?
I want to use a cell in the current workbook to reference a cell in another workbook. Essentially I have a lot of copies of the same formatted data and I'm trying to compile a summary. Is there a wa...
If you mean that you want to reference a cell in another sheet in the same workbook, you can use the INDIRECT function:
=INDIRECT("'"&H2&"'!L11")
This can be filled to the right.
Is it possible to do this when referencing a sheet in another workbook? kczyzyk