Instead of using code, what about just auto filtering by the start date in the second column?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Archengineer"

wrote in message
I have two columns of data. The first column contains five-digit "project"
numbers, the second column contains a starting date (m/d/y) associated with
the project. The numbers and dates are random.

In a third column I have generated a list of dates that are in sequential
order starting with 01/01/2000. To the right of each of these sequential
date cells I would like a cell to list all of the project numbers that
started on that date. There could be up to 12 projects starting on any one
date. I'm not sure how to accomplish this....any help would be appreciated.