I have a spreadsheet (see attached example) which has hyperlinks from one page to another (basically, more detail). I got tired of manually editing each hyperlink when I added a new row, so I went looking for ways to drag hyperlinks like a series, instead of having it just copy the previous one. Now I have a formula that works, but the hyperlink displays "Date", or some numeric code, and I want it to disply "Click Here". Any ideas on how to do that?
Last edited by jomili; 03-10-2010 at 12:08 PM.
Format the cells as General, then use this formula:
=HYPERLINK("#"&CELL("address",INDIRECT("ActionItemDetail!B"&ROW())), "Date")
You can make the text string at the end say anything you want.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Amazing! I only had to change one part of my formula, and now it works like magic. Thanks so much for your quick response and good help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks