How do I collate individual timesheets into one sheet?
 

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 !!! :-)

How do I collate individual timesheets into one sheet?
 

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.
--
Gator


"Nikki27" wrote:

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 !!! :-)

How do I collate individual timesheets into one sheet?
 

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
"Gator" wrote:

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.
--
Gator


"Nikki27" wrote:

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 !!! :-)

How do I collate individual timesheets into one sheet?
 

If you google "multiple consolidation ranges pivot table" you should
get a lot of hits, for example:

http://www.contextures.com/xlPivot08.html

Each timesheet should have the same number of columns, with the same
headers at the top of each column.

HTH,
JP

On Mar 20, 11:48*am, Nikki27
wrote:
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.

How do I collate individual timesheets into one sheet?
 

Access database would work well for that. Are you familiar with Access?
--
Gator


"Nikki27" wrote:

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
"Gator" wrote:

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.
--
Gator


"Nikki27" wrote:

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 !!! :-)