Linking sheets to summarize data

R

Robertya

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare difference between 2 worksheets 2003 1
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
How to summarize copied data 2
Summarize information on different sheets of the workbook 1
Multiple lookup values and adding multiple rates across together 5
Summarize the monthly recrods by name 3
EXCEL 0
How to prevent cell value to change after data input? 5

Top