Building a Hotlink from a formula

  • Thread starter Thread starter RuKannon
  • Start date Start date
R

RuKannon

Hello. I have tried a few unsuccessful runs at this, so was wondering
if anyone who has done this could help me out.

Workbook A contains one tab per person, with a detail record of assets
assigned to that person. I've named the Tabs (manually) according to
the following pattern:

Employer_Lastname_Firstname

Spreadsheet B consists of a table listing all the people detailed in
Workbook A and info on disposal of their inventory. The header row is:

A B C D E
Employer Lname Fname TermDate Disposal etc

I want to create a column in Spreadsheet B that generates a hotlink to
the relevant tab in Workbook A. I can work out the Text string
function:

="[WorkbookA]#" &A2 &"_" &B2 &"_" &C2 &"!A$1"

But it's just a dead text string, not a hotlink. When I try to use
=Hotlink, it seems to want me to create a "Friendly Name" from a cell
on Spreadsheet B.

Am I missing something here?

Thanks.
 
There's a worksheet function named =hyperlink() that may do what you want.

This (hardcoded) example worked ok for me:

=HYPERLINK('[book 2.xls]Sheet3'!$C$99,"ClickMe")

Maybe you can use it to build your formula.
Hello. I have tried a few unsuccessful runs at this, so was wondering
if anyone who has done this could help me out.

Workbook A contains one tab per person, with a detail record of assets
assigned to that person. I've named the Tabs (manually) according to
the following pattern:

Employer_Lastname_Firstname

Spreadsheet B consists of a table listing all the people detailed in
Workbook A and info on disposal of their inventory. The header row is:

A B C D E
Employer Lname Fname TermDate Disposal etc

I want to create a column in Spreadsheet B that generates a hotlink to
the relevant tab in Workbook A. I can work out the Text string
function:

="[WorkbookA]#" &A2 &"_" &B2 &"_" &C2 &"!A$1"

But it's just a dead text string, not a hotlink. When I try to use
=Hotlink, it seems to want me to create a "Friendly Name" from a cell
on Spreadsheet B.

Am I missing something here?

Thanks.
Click to expand...
 
Dear Dave & RuKannon

I can't help RuKannon,

but to know =HYPERLINK() formula did saved my day!

Thank you both

readme dot txt


Dave Peterson said:
There's a worksheet function named =hyperlink() that may do what you want.

This (hardcoded) example worked ok for me:

=HYPERLINK('[book 2.xls]Sheet3'!$C$99,"ClickMe")

Maybe you can use it to build your formula.
Hello. I have tried a few unsuccessful runs at this, so was wondering
if anyone who has done this could help me out.

Workbook A contains one tab per person, with a detail record of assets
assigned to that person. I've named the Tabs (manually) according to
the following pattern:

Employer_Lastname_Firstname

Spreadsheet B consists of a table listing all the people detailed in
Workbook A and info on disposal of their inventory. The header row is:

A B C D E
Employer Lname Fname TermDate Disposal etc

I want to create a column in Spreadsheet B that generates a hotlink to
the relevant tab in Workbook A. I can work out the Text string
function:

="[WorkbookA]#" &A2 &"_" &B2 &"_" &C2 &"!A$1"

But it's just a dead text string, not a hotlink. When I try to use
=Hotlink, it seems to want me to create a "Friendly Name" from a cell
on Spreadsheet B.

Am I missing something here?

Thanks.
Click to expand...
Click to expand...
 
Newsgroups are your friend!
Google is your friend!
Excel's Help is a friend, but not as nice!
And rightclicking is your very good friend!


Dear Dave & RuKannon

I can't help RuKannon,

but to know =HYPERLINK() formula did saved my day!

Thank you both

readme dot txt

Dave Peterson said:
There's a worksheet function named =hyperlink() that may do what you want.

This (hardcoded) example worked ok for me:

=HYPERLINK('[book 2.xls]Sheet3'!$C$99,"ClickMe")

Maybe you can use it to build your formula.
Hello. I have tried a few unsuccessful runs at this, so was wondering
if anyone who has done this could help me out.

Workbook A contains one tab per person, with a detail record of assets
assigned to that person. I've named the Tabs (manually) according to
the following pattern:

Employer_Lastname_Firstname

Spreadsheet B consists of a table listing all the people detailed in
Workbook A and info on disposal of their inventory. The header row is:

A B C D E
Employer Lname Fname TermDate Disposal etc

I want to create a column in Spreadsheet B that generates a hotlink to
the relevant tab in Workbook A. I can work out the Text string
function:

="[WorkbookA]#" &A2 &"_" &B2 &"_" &C2 &"!A$1"

But it's just a dead text string, not a hotlink. When I try to use
=Hotlink, it seems to want me to create a "Friendly Name" from a cell
on Spreadsheet B.

Am I missing something here?

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top