HI,
I'm trying to filter with a macro but get stuck in the criterial part.
in sheet3 cell x1 I have "950 Seafood". This is what I want to filter by in sheet 4
Range("A6").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=Sheets("3").[x1].Value
The above formula doesn't seem to work, any ideas??
I'm trying to filter with a macro but get stuck in the criterial part.
in sheet3 cell x1 I have "950 Seafood". This is what I want to filter by in sheet 4
Range("A6").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=Sheets("3").[x1].Value
The above formula doesn't seem to work, any ideas??