| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Macro filter
Put in a dummy column where you subtract the two dates, then autofilter on
that column. You can get most of the code you need with the macro recorder. Another approach would be to use the advanced filter with a calculated criteria -- Regards, Tom Ogilvy "mister z" wrote in message ... 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 |
| Reply |
| 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)
Linear Mode
