Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Collating and crossing over sheets and workbooks | Excel forum
Resolved · Low Priority · Version Standard
Laura has attended:
Access Introduction course
Excel Intermediate course
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?
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
|
Excel tip:Number format shortcutCtrl+Shift+! applies the Number format, with two decimal places |
We'll call during UK business hours
Server loaded in 0.07 secs.