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
|