From: jmon76 on

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 |

jmon76's Profile:
View this thread: