Pivot table
 

Is it possible to use a pivot table to combined mutable work sheet in
different folders?

Pivot table
 

I didn't think it was possible, but you first pull up the P-T wizard, there
is an option, "multiple consolidation ranges". This will allow you to do
what you wish to do. I ran through it. It is pretty self-explanatory. Good
luck.

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?

Pivot table
 

Thank you Mike H. for your help!

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?

Pivot table
 

Hi Terry

Consolidating multiple ranges in PT's does not behave exactly as you would
expect.

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot08.html

--

Regards
Roger Govier

"Terry" wrote in message
...
Thank you Mike H. for your help!

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?

Pivot table
 

Roger Govier that is an outstanding site, Thank you for you help.

"Roger Govier" wrote:

Hi Terry

Consolidating multiple ranges in PT's does not behave exactly as you would
expect.

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot08.html

--

Regards
Roger Govier

"Terry" wrote in message
...
Thank you Mike H. for your help!

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?