Hello all, I hope you can help. I have queried a database using MSQuer
to create a worksheet with over 28000 clientID's for around 50000 records
The clients can be identified by their ID# in Col A. Each client is eligibl
for one or more programs for a certain time period. Elig from date is in col I,
Elig To Date is in Col J. The Program code is in Col H. About half of
them are listed in several rows (up to around 8) because they are or hav
been eligible for more than one program. I need to create a new worksheet
with a list of unique clientId's with the most current FSEligToDate
I know it can probably be done with formulas, but because of the number o
records, I'd like to do it with code. I'm pretty new to VBE & don't know where
to start. Any help would be greatyl appreciated.

ClientId FundingSourceId FS.EligFromDate FS.EligToDat
83108 4 20030101 2005032
83108 15 20030101 2003063
83108 16 20030102 2003123
83103 15 20030101 2003022
83118 15 20030103 2003123
83118 16 20030818 2004091
83118 22 20030103 2005010

The Results of which would be

ClientID FundingSourceID FSEligFromDate FSEligToDat
83108 4 20030101 2005032
83103 15 20030101 2003022
83118 22 20030103 2005010

I'm using XL2000 & WindowsNT. Thanks in advance
Please post to NG.