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?
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
