Filter between Dates

[shriil]

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

 

[Don Guillett Excel MVP]

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

You could have done wheat I just did. RECORD a macro while doing it.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 9/20/2010 by Donald B. Guillett
'

'
Selection.AutoFilter Field:=1, Criteria1:=">=8/15/2010",
Operator:=xlAnd _
, Criteria2:="<=8/23/2010"
End Sub

 

[shriil]

You could have done wheat I just did. RECORD a macro while doing it.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 9/20/2010 by Donald B. Guillett
'

'
    Selection.AutoFilter Field:=1, Criteria1:=">=8/15/2010",
Operator:=xlAnd _
        , Criteria2:="<=8/23/2010"
End Sub- Hide quoted text -

- Show quoted text -

yes.. but what about selecting the specified range , a user form for
entering start date and end date, and finally outputting the same to
another desired range