Hi
I need to reference a sheet in my workbook by forming the name of the sheet from two separate cells.
Specifically:
Assume my workbook has two sheets, one named MySheet. In this sheet:
Cell A1 has the value query
Cell A2 has the value 123456789
Cell A3 needs to reference a cell (P2) in the second worksheet named query123456789
What do I write in cell A3?
I hope I have illustrated my problem clearly. If not, please let me know what I need to clarify.
All help will be greatly appreciated.
Thanks
RB
Bookmarks