• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Dynamic links to another worksheet in same workbook?

I have a list of values in column A of Sheet1, as the user creates worksheets corresponding to values in Sheet1 I want to create hyperlinks on Sheet1 to the new worksheets.

E.G.

Sheet1 Cell A2 contains a value "001", the user creates a worksheet call "Test-001", is it possible to create a dynamic hyperlink link to cell A1 in the new worksheet?
 
Dynamic so that the formula can be copied down for other cell vaqlues.
0
kieranjcollins
Asked:
kieranjcollins
  • 4
  • 2
1 Solution
 
jsdrayCommented:
=HYPERLINK("c:\test" & A1,"TEST-" & A1)
0
 
jsdrayCommented:
=HYPERLINK("c:\test" & A2,"TEST-" & A2)

pardon me, now it is as you asked...
0
 
kieranjcollinsAuthor Commented:
Is there a way to write this such that it doesn;t reference the file location ?
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
jsdrayCommented:
Sure as long as it's in the same location as the current.
I also realized I  left off the file extension.  Of course, you may need to modify that to your exact preference.

=HYPERLINK("test-" & A2 &".xlsx","TEST-" & A2)
0
 
kieranjcollinsAuthor Commented:
Sorry to be a pain, can one do this without including the filename in the formula?
0
 
jsdrayCommented:
Sorry, but no.  How would it know where to go?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now