Pivot Tables

[Guest]

Hi...

We are maintaining a Report for individual users with details of work done
by them during the day. The Report contains details such as:
1) Date
2) Name
3) Client
4) Version of Work Done

Now, we need an automated Consolidated Sheet with Sum of versions done for
each Client by each Person on a specific Date.

I tried using the Pivot Table... I am not well versed with Pivot Tables. Can
we make a Pivot Table by selection the specific ranges from multiple
(individual) Sheets so that we can get this data...

Please help me with this.

Thanks

 

[JulieD]

Hi

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

for details on how to use multiple consolidation ranges in pivot tables and
the limitations of such.

Cheers
JulieD

 

[Guest]

Hi Julie,

Thanks for sending across the link...

I need the data across a range of dates... For eg: I need the sum of work
done on each day by each person for different clients.

I am not able to do this via this process.

is there any other alternative to this?

 

[JulieD]

have you checked out consolidation under the data menu?