filter a column from other sheet.

[nader]

Is it possible i can type a value in a cell and excel filter in specified
sheet&column by this value?

kind regards

thanks

 

[Gary Brown]

Yes but you'd need a very specific macro.

 

[nader]

hi Gary Brown
thank you for reply and helps.
How can i getting specific macro for following example:

i type a date in "sheet2;A1"and a date in "sheet2;A2" then i want filtering
in sheet1;column F by custom: greater than or equal to"sheet2;A1" And less
than or equal to "sheet2;A2".

sorry; new in english.

many thanks.

 

[Gary Brown]

Here's a macro that would work....

Sub FilterMe()
On Error Resume Next

Selection.AutoFilter Field:=6, _
Criteria1:=">=" & Range("Sheet2!A1").Value, _
Operator:=xlAnd, _
Criteria2:="<=" & Range("Sheet2!A2").Value

End Sub

--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[nader]

Dear Gary
thank you very much; i'm glad to communicate you.

it works successfully but there is a small difficulty;"custom" adjusted by
criteria range (specified value) currently but doesn't filter by this
adjusting and return 00/01/00 date every time. i see format cell in 'date'
but it doesn't work too.