I am having trouble with my VBA code it appears that I need to run the code twice in order to have the code process all of the data. The code should first refresh all pivot tables then copy and paste the data from pivot table 1 to a worksheet. After pasting the data, all negative values need to be moved with their absolute value to the next cell. I need to run the code twice, the first time all of the pivot tables are refreshed and the data is copied but the negative numbers are not moved until the second time running the code, also the negative numbers that are moved are then rounded, which they should not be. Thank you in adavance.

Please Login or Register  to view this content.





End Sub[/CODE]