VBA Dynamic range in Pivot table

J

jmon76

I need to code the following:

I have a pivot table that may contain any number of companies in th
row section and one item in the data section. I am trying to figure ou
how I can code something that will drill down each companies row tota
without naming the companies in VBA and then move the new worksheet to
new book and save it using data contained in one cell. Any suggestions?

In the attached sample, I would want to drill down companies 1 - 10 an
save each file using the name contained in cell B2 of the new workbook.

Thanks in advance for any help or suggestions!


+-------------------------------------------------------------------+
|Filename: Pivot table.doc |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=601|
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Pivot table drill down sort 0
Drill down pivot table data via VBA macro 6
Drop down list control value in vba 2
Selecting Date Range in a Pivot using VBA 0
VBA Pivot Table Error 1
Pivot Table Management 4
Cell Reference and Concatenate 1

Top