Hello,

I have a spreadsheet that may contain many rows. In one column, ex. Column A, there is a number sequence from 1 to 13 and then it starts with 1 again. The problem is that when i import the data to the spreadsheet there might be a row here and there that is missing, due to lack of data for that partickular row in the sequence. I would need a macro that inserts a blank row where ever there is a row missing.

Example:
Column A Column B Column C
1 data data
2 data data
4 data data
5 data data
1 data data
2 data data
3 data data
5 data data
1 data data
...

In this case i would like the macro to insert a row 3 and then a row 4.

I have tried some solutions but they seem only to work on a sequence of continuos numbers. I run into trouble wit a sequence that runs up to 13 and then starts over with one again.

I would be grateful for any input i can get.

Cheers,
Michael