Macro to clean up and format report

[sawan202]

Hi All

I am in need of your expertise, i have pivot table that tracks and summaries till variances per location and would like a macro that would format the report in a more clear and professional way. I have attached a workbook with two tabs on it, one is the export we get and the second tab what we would like the report to look like, I have tried to use recorded macro but unable to make look the desired way so this needs a custom macro.

Much appreciated.

[AB33]

Please Login or Register  to view this content.

[sawan202]

That works perfectly for the number formatting, would you be able to whip up another macro that takes care of the coloring and the conditional formatting, the grid lines, and makes the row bold if a cell contains "Total".

Many thanks

[AB33]

Sawan,
I am not familar with grid lines and coloring, But I have ameded the above code to accommodate the bolding of the "Total" font

Please Login or Register  to view this content.

[sawan202]

Thanks AB33, you have been of great help, nonetheless
Much appreciated