View Full Version : Tab names
jgolden
02-19-2008, 11:25 AM
I want to be able to reference the name of the tabs in the workbook in a summary sheet. However, the order and name of the tabs may change. How can I combine the index number to reflect the name of the tab into a cell on the summary sheet.
Thanks
mdmackillop
02-19-2008, 03:05 PM
You can use Indirect to refer to a range or sheet named in a cell
=INDIRECT(E18 & "!A1")
where the sheet name is in cell E18.
Is this what you're after?
Bob Phillips
02-19-2008, 05:34 PM
If you create a list like so
=MID(CELL("filename",'worksheet 1 name'!A1),FIND("]",CELL("filename",'worksheet 1 name'!A1))+1,255)
for each worksheet. You have to put the name in for the first time, but every time it gets updated, so does your formula.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.