Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

HYPERLINK

Posted by Brian on December 01, 2001 2:13 PM

Can the following be done with a HYPERLINK?

Sheet 1 contains days in a calendar.
Sheet 2 contains people on vacation per day in a range.
Can I enter a hyperlink in cell Dec. 1st on sheet 1 and it automatically takes me to a range in sheet 2 containing all people on vacation on Dec. 1st?

Re: HYPERLINK

Posted by Lewis on December 02, 2001 2:31 AM

You need to name the target cell to form a bookmark.
highlight the cell. Its address appears in the top left hand corner. Click on this and you can edit the address and change it to say Dec1. Press enter. You can now set up your hyperlink from the calender page.
This is all covered in Help under hyperlink to a specific site on a worksheet (or similar)

Regards
Lewis

Re: HYPERLINK

Posted by Brian on December 02, 2001 11:25 AM

Lewis,

Thank-you.....

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.