Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Hyperlinks in Excel workbooks

Posted on 2013-06-28
9
Medium Priority
?
270 Views
Last Modified: 2013-06-28
Is there any way to make a cell hyperlink to a worksheet automatically and when the worksheet opens to open to a specific location of that worksheet
0
Comment
Question by:Jenedge73
  • 5
  • 3
9 Comments
 
LVL 26

Expert Comment

by:pony10us
ID: 39284545
0
 

Author Comment

by:Jenedge73
ID: 39284555
is there any way to make a cell dynamic so depending on what is in the cell will determine where the hyperlink will point?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 26

Accepted Solution

by:
pony10us earned 2000 total points
ID: 39284641
Can you provide a sample of what you mean?

In the meantime here is a basic formula:

=HYPERLINK("#<destination worksheet name>!<destination worksheet column>"&<dynamic cell  eg:  b2>,"<your label for the link>")
0
 

Author Comment

by:Jenedge73
ID: 39284883
=+HYPERLINK(INDIRECT("'"&TEXT(F49,"dd-mmm-yyyy")&"'!$z$88"),TEXT(F49,"dd-mmm-yyyy"))
names of all the worksheets are formatted "dd-mmm-yyyy" and F49 is a date.  And I want the hyperlink to go to that worksheet.
0
 

Author Comment

by:Jenedge73
ID: 39284999
I can't get the hyperlink to open to worksheet.
0
 

Author Closing Comment

by:Jenedge73
ID: 39285095
Thanks works good
0
 
LVL 26

Expert Comment

by:pony10us
ID: 39285168
Glad to help.  I got a little concerned when I saw your sample.  I was going to play around a little more but had to go to a meeting.
0
 

Author Comment

by:Jenedge73
ID: 39285173
No I just had to work with it for a little.  Thanks I really appreciate your help
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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