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