Hi Experts,
I wrote macro to create pivot table and its working fine. Now am thinking if I can color the pivot table / format it with custom colors and borders etc., through VBA or do I have to copy contents of Pivot table to new table to apply colors?
Below is the screenshot of Pivot Table:
T1.JPG
I want to format pivot table (if possible) or create new table based on the pivot values to below table:
T2.JPG
Pivot table cells will always starts from A33 but number of rows will vary. It may grow or shrink.
I will really appreciate any help provided.
FYI: I tried to google and go thru some websites but no help.
Thanks,
Richa
Bookmarks