| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare lists | Excel Discussion (Misc queries) | |||
| compare two lists | Excel Discussion (Misc queries) | |||
| Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
| How do I compare 2 lists and show duplicates as a new list? | Excel Programming | |||
![Jan[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
