linking cells to worksheets within same workbook

V

Veyron

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a number of worksheets within one workbook. The first worksheet contains summary information. Within each cell on this first sheet there is a name which corresponds to a new worksheet within the same workbook , these other worksheets contain detailed information which informs the first sheet. How do I make Excel open the worksheet containing detailed information by selecting the cell on the summary information sheet.
 
C

CyberTaz

There's no specific feature for doing so, but one option is to create a
hyperlink to the target sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning data from the same formula across multiple sheets 1
multiply range of cells 3
Referencing Cells in another workbook 1
reference formula 1
Excel - One Workbook with 13 Worksheets 2
Click on tab opens new workbook 2
Transporting sum from one sheet to another sheet in same workbook 1
changing links to other worksheets on a shared drive 2

Top