Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use autofilter with an equation
I am trying to filter dates such that I want all rows where the date is less
than 30 days forward. In other words I'm looking to see only the rows which are within the next 30 days. In MS-Project VBA I can insert into the Finish Date field autofilter the fo0rmula Value:=(Now() - 28) and get my results Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use autofilter with an equation
Hi
use the advanced filter for this -- Regards Frank Kabel Frankfurt, Germany "ds" schrieb im Newsbeitrag ... I am trying to filter dates such that I want all rows where the date is less than 30 days forward. In other words I'm looking to see only the rows which are within the next 30 days. In MS-Project VBA I can insert into the Finish Date field autofilter the fo0rmula Value:=(Now() - 28) and get my results Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use autofilter with an equation
Frank, how do I Enter the constraints such as all dates between 1/1/2004 and
5/1/2004? "Frank Kabel" wrote in message ... Hi use the advanced filter for this -- Regards Frank Kabel Frankfurt, Germany "ds" schrieb im Newsbeitrag ... I am trying to filter dates such that I want all rows where the date is less than 30 days forward. In other words I'm looking to see only the rows which are within the next 30 days. In MS-Project VBA I can insert into the Finish Date field autofilter the fo0rmula Value:=(Now() - 28) and get my results Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use autofilter with an equation
You can use a Custom AutoFilter. For example:
ActiveSheet.Range("A1").AutoFilter Field:=1, _ Criteria1:="=" & CLng(Date), Operator:=xlAnd, _ Criteria2:="<=" & CLng(Date + 30) ds wrote: I am trying to filter dates such that I want all rows where the date is less than 30 days forward. In other words I'm looking to see only the rows which are within the next 30 days. In MS-Project VBA I can insert into the Finish Date field autofilter the fo0rmula Value:=(Now() - 28) and get my results Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |