Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Junior Member
 
Posts: 21
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
Junior Member
 
Posts: 21
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching two spreadsheets & deleting "False" matches Lily Excel Discussion (Misc queries) 1 June 10th 08 09:38 PM
Checks, Matching and deleting numbers Schwimms Excel Discussion (Misc queries) 2 May 23rd 07 08:59 PM
matching and deleting mrharpo2u Excel Discussion (Misc queries) 4 June 27th 06 01:05 AM
VBA - Deleting Small Text Files ajocius[_48_] Excel Programming 2 January 2nd 06 03:02 PM
Very small macro/VBA stuff, deleting rows. Sintel Excel Programming 6 September 6th 04 05:09 PM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"