I have a table with three columns. In the first column (A), there is always a number for each row (+300).
The number go from 1001 to 5999.
The numbers represent categories:
1000 = Cat A
2000 = Cat B
and so on.
I want to search in column A where the last number, starting with "1", is situated (rownumber). Then I want to insert a row with a new number starting with "1"
So, in my column the numbers go like:
1078
1079
2000
2001
So I want to search for the position between 1079 and 2000 to insert a new row with number "1080" in column "A"
How can I achieve that with VBA by clicking on a commandbutton on a form?
Thx in advance