Thread
:
Linking sheets to summarize data
View Single Post
#
2
Posted to microsoft.public.excel.newusers
pshepard
external usenet poster
Posts: 72
Linking sheets to summarize data
Hi Robertya,
can you send me an example?
"Robertya" wrote:
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?
Reply With Quote
pshepard
View Public Profile
Find all posts by pshepard