Hello

I'm trying to accomplish something in Excel and simply don't know how to go about it. I am a a newbie.

I have a worksheet with data in it

5001 Data Data
5002 Data Data
5005 Data Data
5006 Data Data
5008 Data Data

I need to fill in the missing numbers so it looks like this:

5001 Data Data
5002 Data Data
5003
5004
5005 Data Data
5006 Data Data
5007
5008 Data Data

so, in summary, I need an add-in, marco or some method to add both the missing numbers AND a complete row.

Anyone know of any way to help, or am I stuck manually making these entries?

Remember, I am a complete newbie, please speak simply, I won't be insulted.

Thanks!