Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink changing row
Hi - I have been struggling with this issue and any help is greatly appreciated. Below is the example of two worksheets in the same workbook and I am working with Excel 2003. Sheet1 Sheet 2 Row1 abc abc Row2 def Subabc Row3 ghi def Sheet one contains a master list of requirements. I want to link Sheet1/Row1 with Sheet2/Row2 (doesn't matter what cell). However, the rows can change in Sheet 2 depending if additional sub-requirements are added. The rows will not change in Sheet1. Is there a way to make the hyperlink always point to the correct cell with the insertion or deletion of rows? Thanks - Tess -- tess ------------------------------------------------------------------------ tess's Profile: http://www.excelforum.com/member.php...o&userid=24169 View this thread: http://www.excelforum.com/showthread...hreadid=377948 |
#2
|
|||
|
|||
I think I found the solution to my problem. What I did was named the cells on the different sheets and then from the master list, I hyperlinked them to the name. This may not be the easiest way but it did work. -- tess ------------------------------------------------------------------------ tess's Profile: http://www.excelforum.com/member.php...o&userid=24169 View this thread: http://www.excelforum.com/showthread...hreadid=377948 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Hyperlink Length | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |