Hyperlink cell references

B

Bob

Is there a way to set a hyperlink in one tab to a cell reference in another
(other than manually changing the cell reference in the formula)?

for example:
in Sheet1 H5 I have the fomula =HYPERLINK("[temp.xls]'list'!D2","list") so
when I click in H5 it sends me to D2 in the list tab.

I would like the formula to go down so that Sheet1 H6 links to D3 in the
list tab and so on. I have 65 to 100 rows and I was hoping there was a quick
way to alter the cell references.
 
G

Gary''s Student

In H5 enter:
=HYPERLINK("[temp.xls]'list'!D" & ROW()-3,"list") and copy down
 
B

Bob

Beautiful!

Thank you.

Gary''s Student said:
In H5 enter:
=HYPERLINK("[temp.xls]'list'!D" & ROW()-3,"list") and copy down
--
Gary''s Student - gsnu200838


Bob said:
Is there a way to set a hyperlink in one tab to a cell reference in another
(other than manually changing the cell reference in the formula)?

for example:
in Sheet1 H5 I have the fomula =HYPERLINK("[temp.xls]'list'!D2","list") so
when I click in H5 it sends me to D2 in the list tab.

I would like the formula to go down so that Sheet1 H6 links to D3 in the
list tab and so on. I have 65 to 100 rows and I was hoping there was a quick
way to alter the cell references.
 

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

Top