How do I collate individual timesheets into one sheet?

  • Thread starter Thread starter Nikki27
  • Start date Start date
N

Nikki27

I have several timesheets that I would like to use for each employee.
I would also like a summary sheet that has all of the employees in a drop
down menu. However, how do I do this,so that when I update an individuals
timesheet, the new sheet is also updated?

I have never used macros and have no idea what the simpliest way for me to
do this would be, other than having to update both the individuals sheet and
the full summary sheet, each time there is a change. I am sure that Excel and
you clever things out there have an easier way !!! :-)
 
I'll tell you what Nikki...PivotTables are pretty handy for this sort of
thing. Do you need more info or are you familiar with PivotTables - they are
easy once you get the hang of it.
 
Yes, a bit more info if you wouldn't mind. I have been searching around and
have found ways to consolidate the information, but that is not what I want.

I basically want each timesheet, as it was on the individual sheet, but all
of them together on one additional sheet.

How would a pivot table/report display this and how does it work?
You dont need to go into loads of detail, cos if this is indeed what I need,
then I can figure some of it out as well !! :-)

Many Thanks
 
Back
Top