Macro question

  • Thread starter Thread starter G-MAN
  • Start date Start date
G

G-MAN

I need help with first figuring out whether or not this is possible
and second writing the macro. I have a very large report, 13000
records. There are six columns: account #, name, birthdate, date of
visit, diagnosis, and location. There are many duplicate records.
For example, there may be ten records for Jane Doe. One record has a
date of visit of 10/12/2004 and nine records have a date of visit of
10/13/2004. I need to delete 8 of the nine records with the date of
10/13/2004. I then need to count the number of records with the same
account #. Is this possible?


Thanks in advance for all of your help!!!!

KrisG.
 
send me your sheet - say a few hundred rows & I'll return a solution.

Method : use a class to hold the account and date
use a scripting dictionary to hold the classes. A dictionary has an Exist
method on the keys so that you can easily check if a key exists
use Account number as the key.
the .count property of the class will indicate how many visits per a/c
there are.
Its quite simplistic & I'll post the code too.

regards
 
Patrick, where can I find your email address so I can send the file to
you? My email address is gman3177 "at" yahoo.com

Thanks,
KrisG
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofil on variable rows, delete extract and show remaining rows 3
Data Import from External Database 1
macro to delete rows below the first row with duplicate data 1
Macro Needed Please 9
Validation in child form 1
STRING SUM UNTIL 3
Select random records by two conditions 1
Compare shorter date range against longer date range 2

Back
Top