MATCHING, & DELETING BOTH MATCHES, IN SMALL DATABASE
 

In this section of my macro, I have a small (# of records usually
between 0 and 20) database; each record consists of 10 cells in a row.
There are two subdivisions: call them Range A and Range B (Range A is
records carried over from yesterday and Range B is new records from
today plus some records that are also in Range A). Range A and Range B
may each have between 0 and 10 records.

My desired strategy is to:
have code that finds record duplicates, if any, between Range A and
Range B and then deletes each of the matching records (in Range A and
in Range B). At this point, code is processed based on database
contents. Finally, any remaining records from Range B would be deleted
and the .xls file saved.
At the end of the day, my data file would contain only Range A records
that were NOT matched today.
Is this feasible?

TIA,

JingleRock

MATCHING, & DELETING BOTH MATCHES, IN SMALL DATABASE
 

I have been instructed that 'AdvancedFilter' is what I need to use.
Does anyone have any code that would fit my needs?

TIA,
JingleRock