Updated with Code:
Found code online that I tried to incorporate with my scenario. I am new to VBA and I tried little steps, like fist seeing if I could find duplicates as seen in above code from only one spreadsheet. Now though I am stuck, and I would appreciate your help.
Every two weeks I get a two week list of patients who are coming in to see the doctor. The MRN is unique and the along with the appointment date and time (appt dt) is the primary key. Problem is that some patients from the latter part of the last two week interval may appear in the current installment of the current two week interval. I wanted to make it so that if the patient in the current two week installment has the same MRN and appointment date and time as last week that they do not appear in the current worksheet (maybe create a third worksheet to reflect the unique information).
For example:
First two week interval: Nov 3-23, 2009
Second two week interval:Nov 16-27,2009
Third two week interval: Nov 30-Dec 11, 2009
etc.
Second two week interval: Nov 16-27,2009
appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city11/23/2009 8:30 707777 bryant john Female 3/3/1958 11 wat indianapolis in 46220 317-
Third two week interval: Nov 30-Dec 11,2009
appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city patient-
12/4/2009 8:30 707777 bryant john Female 3/3/1958 11 wat indianapolis in 46220 317-
So now the doctor sees this patient's name twice, although he did see them last week (as shown in the Second two week interval spreadsheet).
Thank you in advance for you patience and help with my question.
These are my columns (and mrn is my unique identifer of each paitent.):
appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city patient-state patient-zipcode patientphone patientencounters-primaryprovidername
I asked this question before on another website. Here is the cross link:
http://www.mrexcel.com/forum/showthr...48#post2154448
Bookmarks