click on cell takes you to specific sheet

[Ron Tarr]

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

 

[HEK]

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

 

[Tushar Mehta]

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