View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ron Tarr
 
Posts: n/a
Default click on cell takes you to specific sheet

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