View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan[_12_] Jan[_12_] is offline
external usenet poster
 
Posts: 3
Default Compare 2 lists and if not on list then delete row

Simple query for you guys, but I can't figure it out.

Basically I have 2 sheets.

Sheet one:

12345 Text text text 4356,00

Sheet two:
12214
12313
32342
23423
32443

I want that the macro checks all the numbers for sheet 2. If there is a
match do change the cellbackground to red. If there is no match, delete
the row in sheet one.

Thanks for your help

--
--
Jan