I have a file with information set up in a sheet like this
Number Name Code
1001 Eric Blue
1003 Jenny Red
1004 Alex Green
1007 James Blue

I want to automatically insert rows where the number skips
and enter in the next sequential number.
Number Name Code
1001 Eric Blue
1002
1003 Jenny Red
1004 Alex Green
1005
1006
1007 James Blue

Any help would be greatly appreciated.