| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Macro filter
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Date Filter | Excel Discussion (Misc queries) | |||
| Filter Date Code for macro | Excel Discussion (Misc queries) | |||
| Filter date in macro | Excel Discussion (Misc queries) | |||
| Macro to filter on today's date | Excel Programming | |||
| Macro to filter on today's date | Excel Programming | |||
![mister z[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
