Macro for grouping/subtotal and row fill by column text value

test2.xlsx

Hi all! I need help creating a macro that does the following:
*Inserts a row above each change in description (Column B);
*puts the "description" in that new row;
*fills those rows with RGB(141, 180, 226);
*bolds the text.

I created this macro to subtotal based on description and adds the count, and then fills the cell with the word "count":

Please Login or Register  to view this content.

It doesn't seem like the prettiest thing, so I would love some help. I was also trying to play around with conditional formatting and tried to add "=ISNUMBERSEARCH(" * Count * ",$A1:$Z1000))" to the macro, but it won't work.

Is there a better way to sort/group based on changes in description as I described other than subtotal? The rows will change drastically over time/between documents, so this was the only way I could figure out to do it. I don't need the "count" of each, just the row inserted above, and this is all I could think of.

Please help!

There are always other ways, but what you have is probably fine. If you're going to run it frequently, you would need to add a line to remove existing subtotals first. You could add a line in your If statement to change "description Count" to "description". You could also add a line to delete the count, but then Excel won't recognize it as subtotals, and when you remove the subtotals it won't remove those rows. If you choose that route, then after removing the subtotals, add a loop to delete those rows.

I haven't worked much with coding for conditional formatting. I could spend some time experimenting, but maybe someone else could jump in on this one?

Thanks, that's great!

I was wondering if there is a way to move the header/value that's created for each new row (from the change in B) into column A, or merge the rows in A and B with that group header?

So that wasn't correct. Any thoughts, please?
--
Ok, I'm trying to figure this out myself, but don't have a computer at the moment to test it. Could I change it to this? I've been having fun trying to parse the code and what each piece means. Haha.

Please Login or Register  to view this content.