Data from pivot table to another excel worksheet

[Raju Radhakrishnan]

Hi,

I need a macro which would take all the Brazilian ports from the pivot table and copy it into a word file. I'll attach both pivot and excel file (How it should copy).

Please help me out in this as this could save me from lot of work. Thanks


Thank you in advance