98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Excel
excel+courses - Excel
Resolved · Low Priority · Version Standard
Thu 17 Jan 2008, 11:46Delegate Edward said...
Edward has attended:
Excel Intermediate course
Excel
How do I get linked grouped work sheet results to a seperate worksheet?
Ed
Mon 21 Jan 2008, 16:46Trainer Katie said...
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
Mon 21 Jan 2008, 18:25Delegate Edward said...
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
Wed 23 Jan 2008, 16:21Trainer Katie said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
