Morning Gang
Attached is a sample workbook using Hyperlinks to navigate easily between locations in the Workbook. The links on 'CU-7'! can remain static as the sheets they point to will not change in anyway to affect the link.
The links at A1 on '07-E-1A'! and '07-E-1B'! are currently static and pointing back to a specific cell on 'CU-7'! These are the Hyperlinks that would need to be dynamic. It is very common to add/delete multiple rows on 'CU-7'! The goal would be to have the Hyperlink point to the cell in 'CU-7'!A:A containg the value from $B$2
Notes in the workbook are in RED text.
Thanks for the help.
Last edited by scaffdog845; 01-13-2012 at 12:38 PM. Reason: Two great solutions provided
Click here to read the Forum Rules
To give a virtual "pat on the back" click the SCALES Icon in the SILVER toolbar from that user's post.
Take a look at this thread. Does it do as you want?
http://www.excelforum.com/excel-gene...html?p=2638625
1) Remove the Hyperlink built into your cell A1.
2) Put this formula in A1 instead:
=HYPERLINK("#'CU-7'!" & ADDRESS(MATCH($B2, 'CU-7'!$A:$A, 0), 1), "Turnaround History")
_________________
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!)
the same thing will work on the CU-7 sheet, too. Remove the hardcoded hyperlinks in column T, then put this formula in T4:
=HYPERLINK("#'" & LEFT(A4, FIND(",",A4)-1) & "'!B2", "Click to View History")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
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!)
It does Whizbang! Thanks for the link.
Click here to read the Forum Rules
To give a virtual "pat on the back" click the SCALES Icon in the SILVER toolbar from that user's post.
JBeaucaire. This worked as well as the other responce and it was a simpler solution fo rthe user who would be dealing with it. Thanks.
Click here to read the Forum Rules
To give a virtual "pat on the back" click the SCALES Icon in the SILVER toolbar from that user's post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks