Can Pivot Table Data to be Customize

[Garold]

Dear all,

Currently i am doing testing on how to use Pivot Table to print payment advice to my customer using Macro but I do face a problem in using it as i need to customize the layout such as i wanted to cut the some of the pivot column to be pasted on the header so is there any trick to do so???

[queuesef]

Having difficulty with your English old chap...your problem needs to be redefined and it would be helpful to have an example! However, you can create formulas off of your pivot table (even simple ADDITION~use " + ") to pull info outside of the pivot table....perhaps this will enhance your layout? You can also cut/paste or create a macro to cut & paste info to a different section of worksheet.