LinkBack URL
About LinkBacks
hi, all of you
I want to filter my table according to the value of range A1, B1, C1 AND D1
when I type value in above cell then it filter my data with cell value
thanx
sample workbook attached
hi, all of you
I want to filter my table according to the value of range A1, B1, C1 AND D1
when I type value in above cell then it filter my data with cell value
thanx
sample workbook attached
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Place this macro in the worksheet code module:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanx Mumps1
Will try in morning
Thanx Mumps1
Will try in morning
Another way
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thanx for the reply both of you
here is a little issue
column d and column e is not going to filter
Thanx for the reply both of you
here is a little issue
column d and column e is not going to filter
Column d and e problem are solved
but
I have a issue in above code...
filter is working after type data in column a, b, or c.....
but i want to filter work as I type in cell,
for example
I type in a1 ....7 then it filter the 7 value with out making Enter or leave cell
And filter is not also working with two criteria
thanx
Last edited by HaroonSid; 01-02-2017 at 07:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks