I'm trying to get a range of dates from one sheet to populate into another sheet. One sheet has dates written as example 02/05/05. In my source sheet I have one of two dates for every month either the 16 or the 31. written as 7/31/05. The date in my source because it is already exsisten defines the range that I need from my target. Example I need all rows with dates between 1/1/05-1/16/05. My question is, how do I set up an array with a selected set of dates?

Any help would be great. I may need to explain better to, but I'm not sure I know how.

Thanks
Nicole