Quick excel help

[audi321]

Hi all, sorry to be a pain but is there an easy way to do the following. On a spreadsheet I have a column which contains groups of data (i.e. below, column C is the groups of data).



What I need to do is after each group finishes, insert another row and some text (always the same text). So it looks something like this:



Any ideas? Thanks for any advice.

[the cueball]

you could use the data subtotal function then add text into the other cells:

https://www.excelarticles.com/excelbook/add_other_...

Without getting all technical and VBA etc etc..

[audi321]

Thanks, I did look at that, but I think I need to have more automation (it seems heavily geared towards subtotals which isn't what I need).

[the cueball]

I think you're going to need to go VBA then..

Something like this could help?

https://www.extendoffice.com/documents/excel/5893-...

[audi321]

the cueball said:

I think you're going to need to go VBA then..

Something like this could help?

https://www.extendoffice.com/documents/excel/5893-...

ABSOLUTELY PERFECT.....thank you.