Formatting an automatically generated worksheet with varying lines of data

Fairly new to VBA, so I'm struggling with how to write a formatting macro for an excel file. The file is automatically generated with each report run, but each report run could have a varying number of rows. How do I write the formatting macro so that I can both format the columns/rows as needed and put in the sum at the bottom of each data?

Thanks, Michele

Michele

How about putting up an example file with 2 sheets. The first sheet shows the before situation, and the second sheet the output format that you require.


rylo