Compare two sheets and delete matched rows.

[gauca001]

Sheet 1 is my master data. Sheet 2 is a newly supplied list. I need to match column D in sheet 2 to column E in sheet 1. Then the macro is to delete the entire matched rows in sheet 2 only, leaving only those unmatched. Attached is a sample file.

Thanks
Tony

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[xlbo]

basic premis
insert formula (index/match or vlookup) to determine if value in sheet2 exists in sheet1 - return true or false
add filer to sheet 2 - filter for TRUE
delete visible rows
remove filter

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Use MS Query to return a DISTINCT resultset of the two tables from a UNION ALL query.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}