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

On Sep 20, 2:27*am, shriil wrote:
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

On Sep 20, 5:10*pm, Don Guillett Excel MVP
wrote:
On Sep 20, 2:27*am, shriil wrote:





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- 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