I want to use the text in A1 to be used in a formula to call another sheet and add data on that sheet. The basic way (that doesn't work) would be (stuff to add)='A1'!A1.
Is there any way to do this?
Hello,
try
=indirect(A1&"!A1")
If the sheet name in A1 contains spaces, you need to enclose it in single quotes
=indirect("'"&A1&"'!A1")
Perfect.
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks