hello~
I am new VB in Excel and need some assistance with the following macro.
Any help greatly appreciated.
I need to create a macro which will start with an initial val in cell A,
tThen move down 1 row and increment the val (example: IM60000107) by one and
if the cell is not blank try and see if it is a match.
If the val does not mtch the val in cell A2, I need to insert a blank row.
Then move down 2 rows (skip the blank row we just inserted), grab the val in
that cell to use as my new criteria for my val to match and start the process
again.
If the val in the next row is a match, I want to increment the val by one
and move to the next row and run the check again. When I hit a blank row (end
of data) I want to exit the loop.