How to insert a thick line after integer row in Excel.
Posted on 2014-07-29
I have an excel document. I have a macro doing a ton of formatting. One of the formatting options organizes the data by names in Column A and then after each name change it adds three spaces.
I'm looking for an additional macro code to then go to columns k-y and for each new person, sum the columns. Each month the row totals will change.
Example Excel Attached. The rows in yellow are the rows i need to create via VBA script. Essentially some how get the script to read down the column selected (B) and when it sees a break in numbers, insert the formula. Then continue down. The number of rows will always be different although in this one its 2 then 1 then 3.