Pivot table - copying & pasting the data into another sheet

I've created a Pivot Table in my macro, with the intention of then copying & pasting the data into another sheet.
However, at current my pivot table looks like this:

Sum of Amount
CPName DealTypeDetailName Total
Abbey Banco Santander

FRN 10900000

Abbey BSCH International

FRN 13000000

Abbey National Treasury Service

CD 10000000
FRN 15000000

Alliance & Leicester Group Tre

CD 25000000

FRN 10000000

Allied Irish Bank Plc

CD 15000000

Anglo Irish Bank Corp Plc

FRN 11000000

ANZ Banking Group Ltd

FRN 43000000

Now as you can see for Abbey National for eg there are two types:CD and FRN. If I paste this data somewhere else, there will be a blank entry for the Abbey FRN. So really I want it to say Abbey National twice, next to both CD and FRN.


Have you got any idea how I can do this within the pivot table, or perhaps how I could add a bit into my macro.

Thanks

hi,

this is the code i use when i have copied the pivot table to another sheet called copyofreport

it looks for the word "grand total" in column a that come from the pivot table
if starts at row a7 as this is where the heading is from the pivot table
bank names?
it looks to see which rows are blank and copies the name from the one above

Please Login or Register  to view this content.

hope this helps

steve