Filter from sheet1 to sheet2

Hello everybody, I'm very new for this. Now I'm an internship at IT Center.

now I have tons of clients' information in sheet1. My task is to

create sheet2 with 2 boxes and a button. when I fill in a keyword

for example, name of client in box1 or client's ip address in box2 (or maybe both),

then I click the button, it will automatically give all information in every rows which contain keyword I type in.

How can I create a VBA for this? Assign Macro at button?

Any help would be much appreciate. Thank you in advance.

Sorry, but you lost me when you say, "give all information in every rows which contain keyword I type in."

If you could post a small file of exactly what the desired result will look like (before and after) that would help a lot.

Originally Posted by Ed_Collins

Sorry, but you lost me when you say, "give all information in every rows which contain keyword I type in."

If you could post a small file of exactly what the desired result will look like (before and after) that would help a lot.

Thank you for your reply. Here I post the file with example in both sheet1 and sheet2.

Please kindly take a look at it.

I'm quite confused with the vba. Please helpp T.T

Play around with this and let me know if this helps you.

example-1 modified.xlsm

Originally Posted by Ed_Collins

Play around with this and let me know if this helps you.

Attachment 236036

Thank you very much. It helps a lot! One more question, if I want to fill in 'anything' in the box

not just province and name, how to do that?

Well... right now if you want filter the criteria by Number or by Surname or IP, the program will have to be modified. Currently it's only searching by Province, if that province box is filled in, and/or by First Name, if that first name criteria box is filled in. (As per your example.)

Ideally, just use my code as an guide, and add another couple of criteria boxes, and modify the code to search the two boxes in the same manner.

If you don't add two more criteria boxes, the logic becomes a bit trickier. For example, if you don't add two more boxes, but you enter a surname in the first name field, the program would have to be "smart enough to know" (figure out) that the name you're entering is a Surname and not a first name. Or, it has to "know" that you're entering an IP address and search the IP column, instead of say a name column or a province column, etc.

wow! that helps a lot. I must ask your permission to use your code as a guide.
Thank you again. I'll try to implement it in order to meet the requirement as much as possible.