Linking worksheets in a workbook

M

Michelle

Hi all

I have been trying to dig this up on the web but cant find it. I have a workbook with two identical worksheets and functions with differnt names. The first week sheet is expanded to show everything. The other sheet has everything hid except for the titles and totals basically a summary sheet. You click on the title and it hyper links you to that revelant rows of data

What I want though is for the total values that are on the expnded sheet to reflect on the summary sheet. Is there away to refrence an entire sheet so that what ever changes are made on one it always shows up on ther other.
 

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

Sumif apllying to all sheets in workbook 2
summary values across worksheets within the same workbook 2
Excel 2007 - Linking workbooks 1
Excel Workbook with Multiple worksheets 2
Help with an IF Statement 1
Linking to other worksheets 3
How to sum one cell across workbook if nr of worksheets is variabl 2
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0

Top