Pivot Tables
 

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

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

"Venugopal Chakkoth" wrote in
message ...
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

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

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

"Venugopal Chakkoth" wrote in
message ...
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

have you checked out consolidation under the data menu?

"Venugopal Chakkoth" wrote in
message ...
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" wrote:

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

"Venugopal Chakkoth" wrote
in
message ...
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