Sheet 1 is a summary. Each value comes from an underlying sheet.

Is there a way of clicking on the cell and it will jump me to the specific
sheet. With 40 or so sheets it is hard to remember which sheet generates the
value on sheet 1.

Thank you

You can make a hyperlink which lets you jump to a specified cell in a
specified worksheet with Insert / Hyperlink.. /Place in This Document .
GL,
Henk

"Ron Tarr" wrote:

> Sheet 1 is a summary. Each value comes from an underlying sheet.
>
> Is there a way of clicking on the cell and it will jump me to the specific
> sheet. With 40 or so sheets it is hard to remember which sheet generates the
> value on sheet 1.
>
> Thank you

In article <79A2A001-9FDE-4F3D-8EDB-(E-Mail Removed)>, =?Utf-8?B?
Um9uIFRhcnI=?= <Ron (E-Mail Removed)> says...
> Sheet 1 is a summary. Each value comes from an underlying sheet.
>
> Is there a way of clicking on the cell and it will jump me to the specific
> sheet. With 40 or so sheets it is hard to remember which sheet generates the
> value on sheet 1.
>
> Thank you
>
Check out XL's 'Formula Auditing' Toolbar. The commands on the toolbar are
also available from the Tools | Formula Auditing > submenu.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions