| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking sheets to summarize data
I have a spreadsheet which has employee details on. One sheet has main
details Employee no., salary, pension %, job grade, job title etc. Then I have another sheet with department on by month as staff regularly move across departments. The other sheets have employee no. and name and then calculations for each month, the sheets are salary (based on total salary), pension based on %, NI based on Salary, Bonus calc based on salary and grade etc. How can I get a summary of the costs by month by department, I cant see anyway of linking the employee no and department to a summary sheet. Any ideas suggestions? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Linking sheets to summarize data
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking data between sheets | Excel Discussion (Misc queries) | |||
| Summarize data from multiple sheets | Excel Discussion (Misc queries) | |||
| SumIF to summarize amount in different sheets by date | Excel Worksheet Functions | |||
| What function do I use to summarize data levels on three sheets? | Excel Worksheet Functions | |||
| Charting series in different sheets (summarize) | Charts and Charting in Excel | |||
Linear Mode
