=HYPERLINK("#"&CELL("address",'YTD Income Summary - ANY'!A1),"ClickMe")

should go to A1 of 'YTD Income Summary - ANY'

(And you said that this is all internal to the workbook--so that name isn't
important.)



Karenatallied wrote:

I've been trying to work these suggestions into my formula but i'm not sure
if i am understanding what each argument means to enter it properly.

=HYPERLINK - i understand is the formula

("#"&CELL - does this represent something else other than what it
is... meaning
do i type this in as is or am i supposed to replace
it with an actual cell
reference?

("address",sheetone!C5), - i took this to mean the actual path to the
worksheet and
cell i'm trying to link to.. whe
("address", - means the workbook the sheets are located in

sheetone!C5), - means the sheet name and cell reference
perhaps this is where my mistake is?

sheetone!C5) - being the text in the linked to worksheet/cell being used
as a name
for the hyperlink

so this what i came up with.... but i get a #VALUE! error

=HYPERLINK("#"&CELL("New York",'YTD Income-Summary -
Cons'!A1),"Consolidated")

where "New York" is the workbook both sheets are in
where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
where !A1 is the cell i would like to link to
where "Consolidated" is the name i would like to name the link on the link
from
worksheet

can you tell what it is i'm doing wrong?

thanks.

"Dave Peterson" wrote:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Karenatallied wrote:

Hi Guys,

the scenario is as follows:

i am trying to link from a "Table of Contents" sheet to cell "A1" in a sheet
named "YTD Income Summary - ANY" and naming the link cell "New York Only".
Both the "Table of Contents" sheet and the "YTD Income Summary - ANY" sheet
are in the same workbook named "New York".

I used the HYPERLINK function shown below:
=HYPERLINK('YTD Income-Summary - ANY'!A1,"New York Only")

and also tried manually editing the formula as follows:
=HYPERLINK("[new york]'YTD Income-Summary - Cons'!A1","Consolidated")

where the sheet being linked to is "YTD Income-Summary - Cons", the link
cell is named "Consolidated" on the "Table of Contents" sheet and the
workbook containing both sheets is named "New York"

I get the same error message in both situations.

any insight would be appreciated...

Thanks :)

--

Dave Peterson


--

Dave Peterson