VBA Dynamic range in Pivot table
 

I need to code the following:

I have a pivot table that may contain any number of companies in the
row section and one item in the data section. I am trying to figure out
how I can code something that will drill down each companies row total
without naming the companies in VBA and then move the new worksheet to a
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 and
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|
+-------------------------------------------------------------------+

--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204937

http://www.thecodecage.com/forumz