Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been instructed that 'AdvancedFilter' is what I need to use.
Does anyone have any code that would fit my needs? TIA, JingleRock |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching two spreadsheets & deleting "False" matches | Excel Discussion (Misc queries) | |||
Checks, Matching and deleting numbers | Excel Discussion (Misc queries) | |||
matching and deleting | Excel Discussion (Misc queries) | |||
VBA - Deleting Small Text Files | Excel Programming | |||
Very small macro/VBA stuff, deleting rows. | Excel Programming |