If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel formula using bookmark name: create click-link
I already used Insert, Name, Create, Left column, to automatically assign a
named cell location (i.e., bookmark) at first line only of each author's books in a tall alphabetic list of many authors and many books per author. This will be my GoTo spot. Now a separate worksheet acts like a master index -- it lists just authors names, which I want to make into clickable links, each going to first line of its own author's portion of the book list. I do NOT want to manually use the link wizard (Insert, Hyperlink) one at a time on each author's name, as there are many dozens of names. How can I use a formula to do this? I tried several ways with HYPERLINK, but so far could not make it work. |
#2
|
|||
|
|||
Excel formula using bookmark name: create click-link
Let's say Ayn Rand's books start at A1000 and we have assigned the Name
Rand_Ayn to that cell. In column B we have a simple list of the authors, so in B1 we have Rand_Ayn. In C1 enter: =HYPERLINK("#" & B1,B1) This will produce a nice "clickable" link to cell A1000. This is a good example of setting up an internal hyperlink to a Named Range. -- Gary''s Student - gsnu200770 "4mula freak" wrote: I already used Insert, Name, Create, Left column, to automatically assign a named cell location (i.e., bookmark) at first line only of each author's books in a tall alphabetic list of many authors and many books per author. This will be my GoTo spot. Now a separate worksheet acts like a master index -- it lists just authors names, which I want to make into clickable links, each going to first line of its own author's portion of the book list. I do NOT want to manually use the link wizard (Insert, Hyperlink) one at a time on each author's name, as there are many dozens of names. How can I use a formula to do this? I tried several ways with HYPERLINK, but so far could not make it work. |
Thread Tools | |
Display Modes | |
|
|