Pivot Tables - Multiple Consolidation Ranges
 

Hi all. I use Pivot tables quite frequently to do consolidations.
Since I frequently consolidate up to 100 or more workbooks at a time
it's kind of a pain to enter all of the ranges separately in step 2b
of the Pivot Table Wizard. I'm thinking there must be a way to maybe
use VBA to: 1) Enter the ranges to consolidate without me having to
manually enter. 2) Construct the Pivot Table. I'm a novice at VBA
and I did use the recorder to see if I could figure the necessary code
on my own but I'm at a standstill.

Can anyone point me in the right direction?

Many Thanks
Andrew

Pivot Tables - Multiple Consolidation Ranges
 

Hi Chuck

I don't work with Pivot tables frequently so I don't have
a answer for you at the moment.

You can find information on this site's
I hope you find what you are looking for

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/...ivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Chuck Harkes" wrote in message om...
Hi all. I use Pivot tables quite frequently to do consolidations.
Since I frequently consolidate up to 100 or more workbooks at a time
it's kind of a pain to enter all of the ranges separately in step 2b
of the Pivot Table Wizard. I'm thinking there must be a way to maybe
use VBA to: 1) Enter the ranges to consolidate without me having to
manually enter. 2) Construct the Pivot Table. I'm a novice at VBA
and I did use the recorder to see if I could figure the necessary code
on my own but I'm at a standstill.

Can anyone point me in the right direction?

Many Thanks
Andrew

Pivot Tables - Multiple Consolidation Ranges
 

Turn on the macro recorder and set up your pivot table with a small number
of workbooks.

then modify the recorded code to do what you want.

--
Regards,
Tom Ogilvy

Chuck Harkes wrote in message
om...
Hi all. I use Pivot tables quite frequently to do consolidations.
Since I frequently consolidate up to 100 or more workbooks at a time
it's kind of a pain to enter all of the ranges separately in step 2b
of the Pivot Table Wizard. I'm thinking there must be a way to maybe
use VBA to: 1) Enter the ranges to consolidate without me having to
manually enter. 2) Construct the Pivot Table. I'm a novice at VBA
and I did use the recorder to see if I could figure the necessary code
on my own but I'm at a standstill.

Can anyone point me in the right direction?

Many Thanks
Andrew

Pivot Tables - Multiple Consolidation Ranges
 

modify to total colomn.

Regards
Ruud

Tom Ogilvy wrote in message ...
Turn on the macro recorder and set up your pivot table with a small number
of workbooks.

then modify the recorded code to do what you want.

--
Regards,
Tom Ogilvy

Chuck Harkes wrote in message
. com...
Hi all. I use Pivot tables quite frequently to do consolidations.
Since I frequently consolidate up to 100 or more workbooks at a time
it's kind of a pain to enter all of the ranges separately in step 2b
of the Pivot Table Wizard. I'm thinking there must be a way to maybe
use VBA to: 1) Enter the ranges to consolidate without me having to
manually enter. 2) Construct the Pivot Table. I'm a novice at VBA
and I did use the recorder to see if I could figure the necessary code
on my own but I'm at a standstill.

Can anyone point me in the right direction?

Many Thanks
Andrew