I'll try - hopefully screenshots will make it clearer... also, I said 25 rows in total before - sorry, it should be 26!Seems like you're doing it correctly. Can you post more sample data so I can try to see what is happening?
This is the list I receive - there are about 100 "groups" of between 1 to 25 all in a long list... column C is how they are numbered etc
And this is the format it needs to be in - all the groups separated consistently with 25 rows, plus 1 extra row marked in orange etc... so there is always 25 rows between each orange row
When I run your code - it seems to work on the first group fine, but then carries on inserting rows afterwards, so pushing the rest of the data continuously down...
Thank you again!