I don't know if I specifically need the code more than a kick in the right direction with this problem.

Database = DB (1200 rows/records)

[Open] [Close] [Item] ... [Status] <-- HEADER
[date] [date] [Description1] [E1]
[date] [<blank>] [Description1] [L2] <-- stop here and ask
[date] [date] [Description2] [E1]
[date] [<blank>] [Description1] [L2] <-- stop here and ask

I would like to more or less duplicate the Excel find function where the find will search down the Item column to find the next instance of the search criteria. In this case I would like to use the search string "desc" or "script" (not both... not an OR statement but two different scenarios). Now the way the Excel find command would work is that it would stop at the first record. I would like it to stop in the second record based on the offset -1 (Close column) = <blank> AND left(Status column,1)="L". If all three of those criteria are met I would like it to stop and ask if it is the correct record. If not it will search again using the currently found record as its starting position to find the second and subsequent criteria matches until it reaches the end of DB Item column. If the end of the Item column is reached and no match found it will display a record not found message, offer to edit the search string, and start again.

Any guidance to this solution or how to approach this problem would be greatly appreciated.