Solved

Dynamic links to another worksheet in same workbook?

Posted on 2013-05-24
6
160 Views
Last Modified: 2013-11-06
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
Comment
Question by:kieranjcollins
  • 4
  • 2
6 Comments
 
LVL 9

Expert Comment

by:jsdray
ID: 39194005
=HYPERLINK("c:\test" & A1,"TEST-" & A1)
0
 
LVL 9

Expert Comment

by:jsdray
ID: 39194010
=HYPERLINK("c:\test" & A2,"TEST-" & A2)

pardon me, now it is as you asked...
0
 

Author Comment

by:kieranjcollins
ID: 39194230
Is there a way to write this such that it doesn;t reference the file location ?
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 9

Accepted Solution

by:
jsdray earned 500 total points
ID: 39196121
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
 

Author Comment

by:kieranjcollins
ID: 39198654
Sorry to be a pain, can one do this without including the filename in the formula?
0
 
LVL 9

Expert Comment

by:jsdray
ID: 39608329
Sorry, but no.  How would it know where to go?
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question