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'?

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.

Todd wrote:

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

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" wrote in message
...
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'?

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" wrote:

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" wrote in message
...
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'?

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




"Todd" wrote in message
...
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" wrote:

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" wrote in message
...
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'?

InsertHyperlink

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


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 13:17:05 -0800, Todd wrote:

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" wrote:

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" wrote in message
...
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'?

Gord,
Thanks! Exactly what I was looking for.

"Gord Dibben" wrote:

InsertHyperlink

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


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 13:17:05 -0800, Todd wrote:

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" wrote:

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" wrote in message
...
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'?

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

"Gord Dibben" wrote:

InsertHyperlink

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


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 13:17:05 -0800, Todd wrote:

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" wrote:

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" wrote in message
...
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'?

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

On Wed, 1 Apr 2009 12:40:05 -0700, rmpete
wrote:

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

"Gord Dibben" wrote:

InsertHyperlink

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


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 13:17:05 -0800, Todd wrote:

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" wrote:

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" wrote in message
...
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'?