Aouto filter by macro
You are welcome! Thanks for the feedback!
Stefi
€žnader€ť ezt Ă*rta:
HI Stefi
it works well.
any thanks.
nader
"Stefi" wrote:
Try this way:
Selection.AutoFilter Field:=6, _
Criteria1:="=" & Sheets("Sheet2").Range("A1").Value
Regards,
Stefi
€žnader€ť ezt Ă*rta:
hi all dears
i need your helps
I use following mocro:
Sheets("Sheet1").Select
Selection.AutoFilter Field:=6, _
Criteria1:="=" & Range("Sheet2!A1").Value
I need to filter(All) by putting a value in cell ("Sheet2!A1").
Thanks.
|