Macro to Sum Columns based on Headers

Okay so I'm fairly new to VBA but I've managed to to get this to partially work. I'm trying to make this sum the Columns and Bold the totals at the bottom of the Column based on the headers which will always be in the first row and start at Column M. I just don't know how to get it to search through the other headers it always stop after summing the first Column. I'm not sure if it has something to do with not making my sum formula variable instead of setting it at Column M.

I've also included the ActiveWorkbook.Sheets line because I plan to eventually alter it to also repeat this process on a Sheet named Sheet2 after completing Sheet1 but I'm not sure if this line is the way to do it.

Please Login or Register  to view this content.

Hello Jluc,

This macro will add the bold total line with the sum formula to each column header (starting at column "M") that matches your headers list. The list is marked in bold. You can add to or remove from the list if you want.

The worksheet checked is "Sheet1". You can change this to another worksheet as well.

Please Login or Register  to view this content.

Which version of Excel are you using?

This is a function of the Table feature in Excel 2010