T
Terry
Is it possible to use a pivot table to combined mutable work sheet in
different folders?
different folders?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H.
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.
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.
T
Terry
Thank you Mike H. for your help!
R
Roger Govier
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
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
T
Terry
Roger Govier that is an outstanding site, Thank you for you help.