Computing.Net > Forums > Office Software > Hyperlinking Worksheets in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Hyperlinking Worksheets in Excel

Reply to Message Icon

Name: dcormode
Date: April 9, 2006 at 11:09:38 Pacific
OS: XP
CPU/Ram: P4/512
Product: Dell Dim 2400
Comment:

I have an Excel Wkbk with one source data sheet with x fields of data. The source data sheet is copied to x additional worksheets and each additional worksheet is indexed by one of the x fields.

How can I jump to the same record in another indexed data sheet when clicking on one of the unindexed cells?

R/

Dan



Sponsored Link
Ads by Google

Response Number 1
Name: rhawk7938
Date: April 9, 2006 at 15:36:16 Pacific
Reply:

Insert, hyperlink, bookmark, then type in the cell reference on the sheet you want.


0

Response Number 2
Name: dcormode
Date: April 20, 2006 at 17:16:44 Pacific
Reply:

Thanks for the reply, but the taskmis more complicated.

I have a source data spredsheet replicated 3 or more times and each worksheet is sorted on a different column (part number, index number, etc).

For example, I want to hyperlink from an index number on the worksheet sorted by index number to the same record on the part number indexed worksheet.

Any suggestions?

R/

Dan


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Hyperlinking Worksheets in Excel

Merging Two Worksheets in Excel 97 www.computing.net/answers/office/merging-two-worksheets-in-excel-97/2032.html

printing multiple worksheets in excel in colo www.computing.net/answers/office/printing-multiple-worksheets-in-excel-in-colo/9395.html

Shortcut Key In EXCEL www.computing.net/answers/office/shortcut-key-in-excel/1481.html