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 , ?B?
Um9uIFRhcnI=?= <Ron 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