linking worksheets

[Todd]

I'm creating a large spreadsheet, made up of many, many individual
worksheets. The information captured on each worksheet is summarized on a
'Summary Sheet' for ease of tracking.

For example, the information manually entered on Tab 1, Tab 2, Tab 3 will be
Summarized on the first tab of the workbook, which is the 'Summary Sheet'

Eventually, there will be so many individual worksheets it will be difficult
to find the individual sheet to update it as necessary.

Is there a way, to jump to the appropriate worksheet from the 'Summary Sheet'?

 

[Dave Peterson]

I don't know how you determine the appropriate worksheet, but maybe you could
use a hyperlink to jump to whereever you want to go.

 

[Conan Kelly]

Todd,

In XL 2003 (&2002) (if you need 2007, you'll have to get that from someone
else, HELP, or search for it):

1. Select the cell that has the formula
2. Tools > Formula Auditing > Trace Precedents
(you can also show the Formula Auditing toolbar so all of the functions are
just a click away)
3. Arrows will be displayed from each cell/range referenced in the
formula to the cell you were on, containing the formula.
(all references to other sheets will have one arrow going to an
icon.....external references)
4. double-click the arrow to move between the referenced cell and the
cell w/ the formula
(When clicking the external references arrow, a "Go To" dialog will pop up
listing all external references in the formula...double-click the reference
you want to go to or click on it once and click the OK button)

After you are done, you can erase all arrows, or you can erase just the ones
for the selected cell (also in Formula Auditing)

HTH,

Conan

 

[Todd]

Thank you Conan,
that works quite well.

however. i have used hyperlinks in the past, to jump to other workbooks.
but, is there a way to use a hyperlink to jump to the worksheet within the
same workbook? is there such a thing?

 

[Conan Kelly]

Todd,

look up the HYPERLINK() function in XL's help:

=HYPERLINK("[File/BookName]SheetName!A1","Text to be displayed in the
cell")

Change "File/BookName", "SheetName", and cell address accordingly.

I don't really have any experience using this function. You might have to
surround your [File/BookName]SheetName in single quotes. Look up the
function in Help for examples.

"Text to be displayed in the cell" can be replaced by a cell reference and
what the value of the cell reference will be displayed in the cell with the
HYPERLINK() function.

HTH,

Conan

 

[Gord Dibben]

Insert>Hyperlink

From the Link to: bar select Place in this document.


Gord Dibben MS Excel MVP

 

[Todd]

Gord,
Thanks! Exactly what I was looking for.

Insert>Hyperlink

From the Link to: bar select Place in this document.


Gord Dibben MS Excel MVP

 

[rmpete]

Great information!
but how would you do it in Excel 97?
Thanks

 

[Gord Dibben]

Been a long time since I used 97 but I think you could select Place in this
document even back then.

Is that not available?


Gord Dibben MS Excel MVP