Jim Thomlinson wrote:
What version of Excel Are you on.

2002 (10.4302.4219) SP-2


It makes a difference as pivot tables have
changed. Here are the basics though. The data that you are exporting
is
perfect for pivoting. Sheet A need to have column headers. Employee
name...
which if I am correct you already have. To get the full power out of
the
pivot table you want to not throw any data away. Just keep appending
the new
information to the bottom of sheet A. You will have to add in the
Dates as I
suggested earlier. Place the cursor anywhere in the middle of the
data and
select Data - Pivot Table. A wizard will come up. You can just
select finish
as Excel will probably make all of the correct decisions for you. You
will
get a new sheet created with a table on the page and the Pivot Table
Tool Bar
displayed. You can just drag the headings onto the table. Employees
in the
right column. Hours in the middle. You can drag more than one heading

(dimension) into the middle, or the right colmn or top row. Anything
you have
added can be moved around by just dragging it. You can group on the
date
heading wich will allow you to group by month, quarter year or
whatever...

This should get you started...

HTH

THANKS JIM!


- Kobi