Finding values

[funkymonkUK]

Hi

I got a worksheet which has 5 columns I want to do a search in column a. Column A has 5 digit numbers. these numbers run in nummeric order.

this is information taken from an old system. Data used to be entered in and the record number ended in 0. Of course this coursed a problem as it used up the numbers quiet quickly and on our old database we could only have 5 digit number. so to rectify the problem we started including 1-9 so now in excel I got a list (see example.xls) where by it runs nummeric order from 80000-80023 and then 80030,80040,80050 how do i run a find that picks up if it exists if it does then tell the user and leave a row and insert next number.

It is really hard to explain so please refer to example.xls

[funkymonkUK]

anybody?

[antoka05]

You can do it with a macro:
Sub InsertRows
rowNumber = Cells(20000, 1).End(xlUp).Row
i = 3
Do While i <= rowNumber
If Cells(i, 1) <> Cells(i - 1, 1) + 1 Then
Rows(i).Insert
Cells(i, 1) = Cells(i - 1, 1) + 1
rowNumber = rowNumber + 1
End If
i = i + 1
Loop
end sub