Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink cell references
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink cell references
In H5 enter:
=HYPERLINK("[temp.xls]'list'!D" & ROW()-3,"list") and copy down -- Gary''s Student - gsnu200838 "Bob" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink cell references
Beautiful!
Thank you. "Gary''s Student" wrote: In H5 enter: =HYPERLINK("[temp.xls]'list'!D" & ROW()-3,"list") and copy down -- Gary''s Student - gsnu200838 "Bob" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink References | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Hyperlink references | Excel Discussion (Misc queries) | |||
how to list what references any givin hyperlink in excel | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |