Hello Everyone

Thanks again for everyone's help!

I'm stuck, I'm starting to wonder if it's because my logical approach is essentially wrong.

This time I'll start from the top.
I have a master sheet with 9000 rows of data approx, this needs to be split into 6 categories, it then needs some columns added, formatting etc. The data within each of the 6 categories then needs to be further broken down and subtotalled, then totalled.

The point I have reached is to begin inserting rows when data in column B changes (which I have done thanks to this forum!). However I now need to insert further rows, when the data in column C changes. I did post this on an earlier thread and thought it worked but it doesn't and suspect this is because there is blank rows.

My other option is to set the whole s/s up manually and just focus on the macros to populate it (the issue with the spreadsheet in the first place was where the number of rows etc changed, very time consuming to change manually!)

I reckon this is as clear as mud so have attached what I've done so far with some dummy data in it. It also contain a version of where I want to be at the end of this project.

Would be grateful for any help / guidance!