Inserting blank rows when data in column changes

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!

You forgot the attachment.

I can't upload the file. It's quite big so I've zipped it and it's within the guidelines.

I am using my work laptop, so have bypassed the network and I still can't upload it.

Any ideas?

Hi everyone

I've spent most of today trying to upload my file so have now given up! I will keep going as I was before!

Below is the code that inserts 6 rows when the data in column B changes. I now need to insert a further two when the data in column C changes

Please Login or Register  to view this content.

This is the code (below) I was given but I think it doesn't work because of the pre existing blank rows created during the last macro. I get an error to do with If block.

Please Login or Register  to view this content.

OMG have managed to upload attachment - have deleted most of it so suspect it was size causing probs. I hope this helps to understand my query.

I've included the steps I'm using to approach this (not sure if they're clear with most of the w/book missing) and would be grateful if someone could check them over, just in case I'm living in cloud cuckoo land!

Thanks again in anticipation!