How do I collate individual timesheets into one sheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nikki27 - 20 Mar 2008 15:59 GMT

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

Reply to this Message

Gator - 20 Mar 2008 16:22 GMT

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.

Signature

Gator

> 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
[quoted text clipped - 5 lines]
> 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 !!! :-)

Reply to this Message

Nikki27 - 20 Mar 2008 16:48 GMT

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

> 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
[quoted text clipped - 9 lines]
> > 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 !!! :-)

Reply to this Message

JP - 20 Mar 2008 16:57 GMT

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

> 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.
[quoted text clipped - 7 lines]
>
> Many Thanks

Reply to this Message

Gator - 20 Mar 2008 17:11 GMT

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

Signature

Gator

> 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.
[quoted text clipped - 21 lines]
> > > 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 !!! :-)

Reply to this Message