Ideas for a Date Array Scan of Data

[NatetheGreat]

Hi there,

I have a series of rows for each date, each row can be any other date, based on the expiration of that item. For example my raw data looks something like below

01/01/2014 data data data 201406
01/01/2014 data data data 201407
01/01/2014 data data data 201408
01/01/2014 data data data 201409
02/01/2014 data data data 201406
02/01/2014 data data data 201407
02/01/2014 data data data 201408

and continues on. I have a key in another sheet telling me which the expiration month row I want for each day, between specific dates i.e.

01012014-19012014 201406
20012014-31012014 201407
etc etc

What I would like to do, is scan through my raw data , and create a new range in a new sheet, that contains only those rows with the expiration months I desire, based on the key.

For example for all rows on each day between 01012014-19012014 I want to only have those rows with 201406 in expiration month column. I would like to do this via a dynamic array rather than a loop and vlookup as the dataset is huge and I would like it to be as quick as possible.

Thanks All

natethegreat