How to search by two columns using vba?

[asilocyra]

These are the columns.

|---ID---|---NAME---|---GRADE---|---COURSE---|

I hope you, guys, can help me with this. What I wanted to do is filter data with two columns.

For example, I ONLY want to filter data that are CS (COURSE) with a GRADE of 900.

Here's my code on filtering one data only. I've used shape as textbox to search on my recent filter data and base those search on an option button.

Can you help me work this out?

Please Login or Register  to view this content.

Thank you!

[maym]

Could you use something like:

Please Login or Register  to view this content.

[asilocyra]

Could you use something like:

Please Login or Register  to view this content.

I've updated my post, maybe you can help me with it?

[Sintek]

Upload sample...

[asilocyra]

Upload sample...

Ohhh. Hi, again. Thank you for looking into this!

https://drive.google.com/open?id=0B4...0VjWXQzTmN6ZVE

[Sintek]

That huge file of your with nothing in.....

[asilocyra]

That huge file of your with nothing in.....

Yea, I'm also wondering why it's like that. :O

[Sintek]

32.6MB i suggest you create a new sheet with criteria.....re upload
Just takes up to much processing power and time when we have to work with it...

Originally Posted by Pete_UK
To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

[danielexcelvba]

I may be misunderstanding what you're asking, but assuming you have your titles in the range "A2:E2", and all the data underneath them, this will copy all rows that meet the two criteria and paste them into sheet 3 with the headings from sheet 1

Please Login or Register  to view this content.

Edit: I now see that you need dynamic user-inputted search criteria nvm

[asilocyra]

32.6MB i suggest you create a new sheet with criteria.....re upload
Just takes up to much processing power and time when we have to work with it...

Hi! Sorry it took me long to get back to you. Anyways, I've already uploaded the file and thank you for teaching me how to do it.

[Sintek]

So please explain what you want to achieve...
You want to filter sheet 1 based on those two criteria.....And then....Copy the info to Sheet3

[asilocyra]

So please explain what you want to achieve...
You want to filter sheet 1 based on those two criteria.....And then....Copy the info to Sheet3

Yes, that's what i wanted to do but i've been stuck there because i don't know how to filter based on two criteria.
But I came up with something like this but I didn't get any far.

Please Login or Register  to view this content.

[Sintek]

This will give you an idea...Will filter Active Sheet based on your stipulated two criteria then copy the filtered rows to Sheet3...If none available will bring up a message..

Please Login or Register  to view this content.

[asilocyra]

This will give you an idea...Will filter Active Sheet based on your stipulated two criteria then copy the filtered rows to Sheet3...If none available will bring up a message..

Please Login or Register  to view this content.

I got it working but how do I pass value to a criteria using a shape or textbox from a control form?

[Sintek]

Try something like this...

Please Login or Register  to view this content.

[asilocyra]

Try something like this...

Please Login or Register  to view this content.

THANK YOU! You saved me, AGAIN! I've been struggling here for days just to get that result XD
THANK YOU SO MUCH! You're my life saver hahaha

Anyways, I also came up with something like that, but it doesn't insert filtered data to another sheet.

Please Login or Register  to view this content.

[Sintek]

Glad i could help...thanks for rep +