Excel Filter Combined with Formula

[John Lie Votacion]

Good day,

I would like to ask if there is a shortcut instead of clicking from your filter button and choosing what you want to filter. Recently my right arm is getting numb due to too much clicking and choosing from the list.



So what i want to know is a FORMULA that If ever I input the Store Code (example: by typing 931 in cell C2) it would instantly filter results with 931 as store code. Right now I still have no idea on what formula to use.

Very much appreciated for any of your replies. Thank you.

 

[NARAYANK991]

Hi ,

Please upload a workbook.

Narayan

 

[John Lie Votacion]

Hi ,

Please upload a workbook.

Narayan

Here it is sir.

John

 

[srinidhi]

Hi John, Paste the data in the data sheet & results can be vied in the Results Sheet. Hope this is what you were looking for...

 

[John Lie Votacion]

Hi John, Paste the data in the data sheet & results can be vied in the Results Sheet. Hope this is what you were looking for...

Hi ma'am Srinidhi,

Thank you ma'am, I like how awesome the results come up. But sometimes it is kinda Lag, or is it my computer who has a problem or the formulas doing this? Anyway, is it possible to make it with this with this whole data madam?

Please see attached file.

Thanks a lot ma'am.

 

[NARAYANK991]

Hi John ,

See the attached file.

Narayan

 

[John Lie Votacion]

Hi John ,

See the attached file.

Narayan

Hi sir,

Thank you for your reply. Sorry to say but it seems not working out.

P.S. I also observed the difference in our file that what you sent me is a .xlsm and not .xlsx - could that be the problem.

Thank you.

 

[NARAYANK991]

Hi John ,

The workbook has a macro , and you need to have macros enabled.

I tried reproducing what you have shown in the image , and it works correctly at my end.

Narayan

 

[John Lie Votacion]

Hi John ,

The workbook has a macro , and you need to have macros enabled.

I tried reproducing what you have shown in the image , and it works correctly at my end.

Narayan

IT WORKS!

THANK YOU VERY MUCH sir.