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 SantanderFRN 10900000Abbey BSCH InternationalFRN 13000000Abbey National Treasury ServiceCD 10000000Alliance & Leicester Group Tre
FRN 15000000CD 25000000FRN 10000000Allied Irish Bank PlcCD 15000000Anglo Irish Bank Corp PlcFRN 11000000ANZ Banking Group LtdFRN 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
Bookmarks