Home

Excel Custom Date Filter with CELL

Highlighted
New Contributor

I am trying to filter a column based on dates, custom date value present in some other sheet say Sheet1 Cell L5. But something is wrong  and I am unable to get it right.

Macro when I manually wrote the value in filter option generated is:

 

Sub CustomDateFilter()
'
' CustomDateFilter Macro
'

'
Range("U1").Select
Selection.AutoFilter
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
ActiveSheet.Range("$A$1:$CU$1077").AutoFilter Field:=21, Criteria1:= _
">='Sheet1!L[5]'", Operator:=xlAnd
End Sub

 

I want the custom value to be cell Sheet1 Cel L5 but I am unable to do this.

can somebody guide ?

Related Conversations
How to filter a text column in excel to more than 2 items
fplopes in Excel on
0 Replies
Conditional formatting using tolerances
MicLima in Excel on
1 Replies
SI.CONDITION
dubkri in Excel on
0 Replies
Help with function
Vicky13 in Excel on
1 Replies
help with exchel
mat81 in Excel on
2 Replies
Excel number format - doesn't read as a number
Hilde250 in Excel on
1 Replies