Lookup and delete line if found

[rpinxt]

So I attached a very simplistic example book to explain what I am looking for.

Say I have accounts 1 to 20 on tab 1 and on tab 2 if have some numbers corresponding with one of the number 1 to 20.
I my example I have 4,7,11,14.

What I was trying with worksheetfunction.vlookup or application.vlookup to lookup the range 1 to 20 on sheet 2.

If the number I was looking op at that time was present on sheet 2 it needs to delete the entire line (an move all up) and check the next number.

Can not get that straight. All help is appreciated.

[davesexcel]

You can loop through the first sheet and use find to see if it is in the second sheet.

Please Login or Register  to view this content.

[rpinxt]

Thanks davesexcel!

A solution with Find is fine by me.
Was looking into vlookup but Find is probably faster anyway as the data has about 1400 lines.