Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink referencing
I have used Bastien Mensink's excellent add-in (ASAP Utilities) to create a
Hyperlink index for many sheets in a workbook (currently 64). A master worksheet has been copied and of course the result has names 'Master', 'Master(1)', Master(2),...etc. I wish to retain the sheet names as created - each sheet has a client name in Cell C2. The generated Index Sheet has in Col A, the names of the sheets and I need to produce in column B the name appearing in Cell C2 according to the link in Index Sheet Col A. What is the method ?. I have tried manually (using =<select C2 on required sheet) and it works perfectly. But I cannot find the function or syntax to get a copyable formula to work. Thanks in advance -- Don C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a Hyperlink from another cell | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |