Hey guys,
Need help with code to do the follolwing:
Project |Project Date |Todays Date
100190 |11-Oct-2005 |10/14/05 08:34 AM
100190 |12-Oct-2005 |10/14/05 08:34 AM
100190 |13-Oct-2005 |10/14/05 08:34 AM
100190 |14-Oct-2005 |10/14/05 08:34 AM
100220 |15-Oct-2005 |10/14/05 08:34 AM
100252 |16-Oct-2005 |10/14/05 08:34 AM
100257 |17-Oct-2005 |10/14/05 08:34 AM
100275 |18-Oct-2005 |10/14/05 08:34 AM
100275 |19-Oct-2005 |10/14/05 08:34 AM

I have 3 columns: Project, Project Date, and todays date.
I would like to filter out all days less than OCT 14th(Today) and + 2
days and spit this to sheet 2. So sheet 2 would show:

Project |Project Date |Todays Date
100190 |11-Oct-2005 |10/14/05 08:34 AM
100190 |12-Oct-2005 |10/14/05 08:34 AM
100190 |13-Oct-2005 |10/14/05 08:34 AM
100190 |14-Oct-2005 |10/14/05 08:34 AM
100220 |15-Oct-2005 |10/14/05 08:34 AM
100252 |16-Oct-2005 |10/14/05 08:34 AM

I tried a few things but nothing was working

Any help is appreciated.
Thx.


--
mister z
------------------------------------------------------------------------
mister z's Profile: http://www.excelforum.com/member.php...o&userid=28099
View this thread: http://www.excelforum.com/showthread...hreadid=477583