Hi,

I would very much appreciate help on the following:

I would like to identify unique values in column A (Bill numbers) for a given date.

There are several rows with the same date in column B, and for a given date there may be several rows with the same bill number.

I would like a VBA sub that will identify all rows in Column B that match a user-defined date and copy only the corresponding unique values of column A.

Here is an example of the data:


Column A Column B
(Bill number) (Bill date)
GNYF008 11/01/2012
GNYF009 11/01/2012
GNYF010 11/01/2012
GNYF011 12/01/2012
GNYF012 17/01/2012
GNYF013 17/01/2012
GNYF013 17/01/2012
GNYF014 18/01/2012
GNYF014 18/01/2012
GNYF014 18/01/2012
GNYF014 18/01/2012
GNYF014 18/01/2012
GNYF015 18/01/2012
GNYF016 20/01/2012
GNYF017 24/01/2012
GNYF018 25/01/2012
GNYF018 25/01/2012
GNYF018 25/01/2012
GNYF019 25/01/2012
GNYF020 25/01/2012
GNYF020 25/01/2012
GNYF020 25/01/2012

Any suggestions of code I could use?

Thanks!