Edward has attended:
Excel Intermediate course
Excel
How do I get linked grouped work sheet results to a seperate worksheet?
Ed
RE: Excel
Hi Edward,
Thank you for your question. Could you elaborate your case so I can understand how these worksheets are grouped? Are there formulas or consolidated or hyperlinked...etc?
Generally to link a specifc cell (dispite it's worksheet origin):
1) Type =
2) Use mouse to click on the original figure
3) press Enter
But there are many other ways to link worksheets.
Regards,
Katie
RE: Excel
Hi Katie,
Thank you for respnding to my question.
I need to establish a method of linking the information on 8 seperated pages to a master sheet. The 8 pages display the same information but from differnt areas. I will tehn use the detail within the master sheet to display perfomance stats in charet data.
Regards
Eddie
RE: Excel
If you have a specifc function in mind, like SUM / AVERAGE / MAX / MIN / COUNT, you can use CONSOLIDATION.
- 1. Open all your files
2. On master sheet, select DATA menu > CONSOLIDATE
3. Choose a function (e.g. SUM)
4. Click in REFERENCE box, select file 1 and data table
5. Press ADD
6. Click in REFERENCE box again & select file 2 data table > ADD. Repeat until all 8 data tables are added.
7. Tick all 3 boxes for labels in TOP ROW, LEFT COLUMN & linking source data
8. Press OK.
This put all data together and the labels are collapsable. See if this is any use to you.
Regards
Katie
