Macro for copying data from pivot table to other workbook

Task:
I need to get some data from pivot table and copied to the summary file according to specific account managers. Previously, I get the useful macro, however, after I run in the office, it has some problems.

After I use in the office, it has the following problems:

1. If the account manager's name in pivot table is Alexander Dyste-99999*, as I run the macro, in the PCT-After.xls, the data of % Primary sales of closed leads (maturing mortgage
maturing term deposit and signficiant deposit) data will be wrong

2. If the account manager's name in pivot table is gordon d Lam 99999e*, as I run the macro, in the PCT=After.xls, the macro doesn't copy any data in the PCT-after.xls

3. After I run macro, in PCT-after.xls, the date in row 22 (for example), it will be ' in the cell rather than the dd-mm-yy (e.g. 18-Jun-11). I create the similar file at home, it works. I don't why there is problem in the office file.



How can I modify the following code, therefore, I can copy data from pivot table to summary file correctly?

Thank you, if you can give me reply and appreciate your effort

This time, I use more than one hour to prepare PCt-desire result excel and PCt-after.xls.
PCT-DESIRE is for my desired result
PCT-after.xls is my simulation file in office

Please Login or Register  to view this content.

Dear all,

May I ask one more thing? After I use the file in office, there are following problems:

1. For each account manager sheet, date will be turned to blank cell. For example, as I use macro to paste data on pct-after.xls, the date in column A of each account manager is deleted.

2. Sometimes, data copied to pct-after.xls on each account manager sheet is wrong.
I give you the following example,

in pivot table, there are 4 account managers, 1. david, 2. john 3. may 4. Gordon.
However, if data of May can't be copied to PCT-after.xls (because of spacing in pivot table, sometime, the account name is like as May 99999*), then data of Gordon copied on the pct-after.xls is incorrect.

Thanks

hi, ronlau, please check attachment, please check if everything is OK