Adding Items to a Multiple Consolidation Range Pivot Table

[Bob Buckland ?:-\)]

Hi Chas,

I'm assuming you're using an Excel pivot table? If so, you may want to use the link below to post to the MS Office Excel discussion
group as well and include there the version of Excel you're using.

=========
I currently have a pivot table created through the pivot table wizard. I
selected to create a pivot table using data from "Multple Consolidation
Ranges", create a single page field, then add the ranges.

My question is, is there a way to add a new range or "item" (to the existing
pivot table) without going through the wizard. I'm trying to incorporate
this process into an existing macro but using the wizard just complicates
things. Currently I have to select the table, go to the wizard & hit the
back button until I get to the step where i can add another range.

I'm not very good with VB yet so I tried recording my steps first but that
gave me a very complicated array which i don't think would work because that
info will change everytime I add or remove a range.

I hope all that made sense. Any help will be greatly appreciated.

Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Chas]

I currently have a pivot table created through the pivot table wizard. I
selected to create a pivot table using data from "Multple Consolidation
Ranges", create a single page field, then add the ranges.

My question is, is there a way to add a new range or "item" (to the existing
pivot table) without going through the wizard. I'm trying to incorporate
this process into an existing macro but using the wizard just complicates
things. Currently I have to select the table, go to the wizard & hit the
back button until I get to the step where i can add another range.

I'm not very good with VB yet so I tried recording my steps first but that
gave me a very complicated array which i don't think would work because that
info will change everytime I add or remove a range.

I hope all that made sense. Any help will be greatly appreciated.

Thanks