I have a pivot table with a filter. The report is formatted differently than the default formatting (i.e. column width made smaller, color shading for columns, light grey dotted lines for cell borders, wrapping text, logos, etc). This is a monthly statement that will be sent out to approx 260 customers.
Then, when selecting "Show Report Filter Pages...:", the worksheets are created correctly for each customer but the formatting is not preserved. My "original" statement still looks really good but the 259 others don't.
How do I get the worksheets generated from the "Show Report Filter Pages" option to use the same format(s) as the original? I'm stumped! I was able to add a VBA to save each one of sheets as a .pdf which helps me out tremendously - but not if none of the formatting can be preserved.
Any help would be so very welcomed.
Then, when selecting "Show Report Filter Pages...:", the worksheets are created correctly for each customer but the formatting is not preserved. My "original" statement still looks really good but the 259 others don't.
How do I get the worksheets generated from the "Show Report Filter Pages" option to use the same format(s) as the original? I'm stumped! I was able to add a VBA to save each one of sheets as a .pdf which helps me out tremendously - but not if none of the formatting can be preserved.
Any help would be so very welcomed.
