Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Collating and crossing over sheets and workbooks
|
|
|
The UK's most regular 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. |
advanced.excel - Collating and crossing over sheets and workbooks
Resolved · Low Priority · Version Standard
Reply Thu 2 Aug 2007, 09:54Delegate Laura said...
Laura has attended:
Access Introduction course
Excel Intermediate course
Collating and crossing over sheets and workbooks
How do I collate information from 2 different workbooks or from 2 different sheets in the same workbook such as one with an amount of days which each employee works and one with how much each day costs for each employee so that I can work out the exact cost and profitability of everyone seperately?
For upcoming training course dates see: Pricing & availability
RE: Collating and crossing over sheets and workbooks
Hi Laura
Thanks for your question.
Working out each person's total will be a multiplication (number of days worked x cost).
If you are doing this where the number of days worked and the cost are on separate sheets in the same file then:
1. Select the cell where you wish to enter the formula.
2. Press =
3. click on the sheet containing the number of days worked and select the cell showing the number of days worked for the person in question.
4. Type in *
5. click on the sheet containing the cost/day and click on the cell containing the cost/day for the person in question.
6. Press Enter.
If the cost/day and the number of days worked are in different workbooks, then you will follow the same procedure, you would just need to make sure both files were open first.
Amanda
|