Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Way to Link Tab Names
I checked this out a few years ago, but thought I might post for an updated
answer. I have a few workbooks linked together and would like to know if there is a way to create an absolute reference between linked tabs regardless of the name of the tab. As new projects are started, tabs get renamed, so we have to have all the workbooks open at once to keep the links active. Maybe there is a way to name the tab to a linked cell, so as a workbook is opened, it looks at the linked cell name for the tab name first to keep the links active? It would also have to work around tabs getting relocated, so references to Sheet1, Sheet2, would probably not work, which is why I thought a cell reference would work around that issue. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Breaking the link | New Users to Excel | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |