hello,
I have a simple pivot table, based upon a datawarehouse, in which I have 2 report filters, the customer and the customer group.
When selecting a customer or a customer group, a bunch of calculations are made in the worksheet for calculating the customer profitability.
I would now like to have a list per customer with all the relevant profitability data. however, we have about 5 000 customers, so I would take me forever to select the first customer, copy the relevant data to a worksheet, selecting the second customer, copy the relevant data to a worksheet, selecting the third customer, etc...
so I would like to make a macro which would do something like this

for i
select pivot table item i
copy range a1, b5 , c8, d4 to worksheet X row i
next

I have no idea how to write the vba for selecting the pivot table items. Can anyone help me?

thanks, steven