How can I reference a sheet by forming the name of the sheet from two separate cells?
I need to reference a sheet in my workbook by forming the name of the sheet from two separate cells.
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.
If posting code please use code tags, see here.
Re: How can I reference a sheet by forming the name of the sheet from two separate cells?
Wow! Thanks so much! Just what I needed.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1