Forum Discussion
How do I reference a cell in another sheet using a value from the active sheet
I want to reference cells in another sheet, I know how to reference them directly but I need to reference them from a value that points to the cell that is in the active sheet. I know this doesn't ...
I think it must be as my sheets are named. If change them back to sheet1 it works.
It's because I have titles with spaces for the sheet names.
I need to change the way it references the sheet.
Thanks
It's because I have titles with spaces for the sheet names.
I need to change the way it references the sheet.
Thanks
If you have space in your sheet names you must add simple quotes around the sheet name, as below:
=INDIRECT("'My Other Sheet'!" & C3)