Search for specific date range, copy entire row and paste to new worksheet

Good morning,
I have a master spread sheet with over 17000 lines each one carring a specific date in column C. Dates range back as far as 1990 to current date. I am looking for a way to pull only the ones that within the next 30 days will reach a over one year mark? same with 60,90,120 and one that is specifically only over 1 year. Each 30,60,90,120,over 1year have thier own worksheet to copy to.


let me know if anyone cane help

Here is a sample, i have several different products and in column b i have the age of the product. I need to sort the age it is coming up to. Any product hitting the one year mark within the next 30 days needs to come up on the Equ30day tab, same with any product coming up to 1 year in the next 60days and so fourth. I need excel to search the list for the 30 day range, copy the entire row and paste to equ tab.

does this help?

MRB12 08/23/12 10UNBX NSNA4Q 10ZZZZ 2L001 AHILL I 1 YES
MRBX3 10/08/10 10UNBX NSNA43 0L007 TECH 1 YES
S2610 04/09/12 10UNBX 2SND2H 10ZZZZ 15086 1 YES
S2610 04/09/12 10UNBX 2SND2H 10ZZZZ 15086 1 YES
FS608 01/02/08 10LEAS NKSB3A 10ZZZZ W YES
LCX1 01/02/13 100000 NSNA3P 10BA88 5E001 AHILL I 3 YES
X555N 01/04/10 10LEAS CXSD0V 40ZZZZ W YES
R4500 01/04/13 10LEAS 3RSE14 W YES
SC401 01/05/09 10LEAS 3SSC06 10ZZZZ 80028 AHILL I W YES
X450X 01/07/08 10LEAS 4XSD0D 10ZZZZ W YES
MCSX2 01/07/09 10LEAS NSSA46 10ZZZZ 9A001 AHILL I W YES
XC560 01/07/13 10UNBX 7XNE07 10G911 XPN39 D YES
XN7LX 01/07/13 10UNBX NXNB1A 110213 PBB00 AHILL I 3 YES