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").SelectSelection.AutoFilterActiveWindow.ScrollColumn = 2ActiveWindow.ScrollColumn = 3ActiveWindow.ScrollColumn = 4ActiveWindow.ScrollColumn = 5ActiveWindow.ScrollColumn = 6ActiveSheet.Range("$A$1:$CU$1077").AutoFilter Field:=21, Criteria1:= _">='Sheet1!L'", Operator:=xlAndEnd Sub
I want the custom value to be cell Sheet1 Cel L5 but I am unable to do this.
can somebody guide ?