Hyperlink changing row

  • Thread starter Thread starter tess
  • Start date Start date
T

tess

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I align cells in Excel onto one line? 2
if statement, change cell only if true 4
Macro help needed 4
Excel 2013 Merge Data 2
Count based on string in cell 2
Same dates in Sheet1 put as one date in Sheet2 6
count a value in a date range based on a date in another workshee. 4
how to compare two columns on two sheets and copy associated data from one sheet to the other? 2

Back
Top