LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Filter between Dates


I have an excel sheet where I keep track of maintenance jobs done
throughout the year. The data looks like as mentioned below:

A1 B1 C1

Descr Job no Job Date

AAA 25/1 12/08/10

BBB 12/2 14/08/10

CCC 30/2 15/08/10

DDD 05/3 02/09/10

.... .... ........

I would like to run a macro where I will filter out the above range
between two dates, (i.e I input a Start Date and a End Date) and copy
the filtered list to a new sheet.

I normally use the Custom Filter Option for doing the same but it
would be very helpful if the same can be run with a code.

Thanks for the help



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter in between dates Linda RQ New Users to Excel 6 November 3rd 09 01:14 AM
Filter on Dates suek Excel Discussion (Misc queries) 4 August 11th 08 04:21 PM
Filter Dates? Ken Excel Discussion (Misc queries) 4 February 20th 07 09:27 PM
How to filter out all the partial dates from a big list of dates? Tiwarr Excel Discussion (Misc queries) 1 September 14th 06 05:35 PM
vba filter dates Duncan_J Excel Programming 3 February 11th 05 08:34 PM


All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"