Formatting data table with macro

[scotth187]

Hi All
Please bear with me I am quite good with simple macros but by no means a VBA expert

I have a macro than runs me 3 different pivot tables which i then copy and paste to a new sheet.
I then want a macro to format these pivot tables......I have written a macro but because the number of rows and columns changes each time a run the pivot tables the formatting macro doesn't work properly.
please see screenshots - capture 8 is the formatting i'm hoping to achive
thanks

[JBeaucaire]

Please read through the forum rules. Link is above in the menu bar. It not only includes the rules you MUST follow, it includes tips for insuring your posts are considered well by all those who might want to help. For instance, post a workbook instead of pictures, the workbook can include BEFORE and AfTER sheets, just like your pictures.

And also, post code in the thread, surrounded by CODE tags, rather than pictures of code. I was tempted to take a picture of the answer I'm giving, then decided not to... this time.

Please Login or Register  to view this content.