What formula should I use to reference the name of worksheet(s) in a cell(s) within the same workbook?
Thank you!
What formula should I use to reference the name of worksheet(s) in a cell(s) within the same workbook?
Thank you!
function indirect
do you want to find the sheet name itself or use as a reference
for the sheet name - see here
https://exceljet.net/formula/get-sheet-name-only
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Is this what you had in mind?
A1 = Sheet1
=INDIRECT("'"&A1&"'!A1")
Evaluates to:
=Sheet1!A1
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks