need help to search on cell value from below row

[chiragdesai884]

I am not able to find this help me to do it.

what I need to do is in row 2 what I type below row should be filtered.
check sample file I have attached. In row c2 and d2 I will write any number and below row should be filtered. how can I do it with VBA or any other way?

 

[Belleke]

Does this help?
See attached.

 

[Marc L]

how can I do it with VBA or any other way?

No need any code just using Excel basics : a filter …
​

 

[Belleke]

@Marc L , nice explantion, I just din't learn shit

 

[Marc L]

Why creating a superfluous code needing a keyboard input
when just with an Excel inner feature you just have to click
on the filter arrow and select an item ?!
Why creating a code for what already exists ? …
​

 

[chiragdesai884]

Does this help?
See attached.

Yes, Sir, your excel solve my problem and this is same I was looking for it. Thank you so much for the solution, but another problem comes because I have given sample file and now I need to do it in my original file so how can I do it? can you give me instruction of it? also, I notice that your extension is .xlsb and my original extension is .xlsm is it possible in my extension?

 

[Marc L]

Yes whatever in .xlsb or .xlsm …

Can be done also with your original attachment like it is
but instead of using cells C2:D2
- as too easy with few codelines at beginner level for a futile need -
this can be directly done with headers row in C1:D1
like for the normal use of the Excel feature !
​

 

[chiragdesai884]

agree I am trying to do the same thing but getting an error. can you help me to solve it out?

 

[Belleke]

Have a look at my example formulas -> defined name ranges you will see a table named numfilter, my quess is that you don't have that in your original file.

 

[chiragdesai884]

I have used the same but error still occur. kindly check attached original file.

 

[Belleke]

I have to go now, will have a look at it later, but I see that you did not create a table but a named range. Create a table.

 

[chiragdesai884]

Thank you so much I have solved this Issue. Yes, It was of Creating a Table.

 

[chiragdesai884]

Really appreciate your time and supports, once again thank you so much.

 

[Belleke]

Glad you solved it.
Have a nice day.

 

[Marc L]

can you help me to solve it out?

Still need from your original attachment ?
​

 

[chiragdesai884]

No, Marc, I have solved the problem with your's supports. Thanks

 

[chiragdesai884]

Glad you solved it.
Have a nice day.

Without your support, it won't be possible