User entered 2 criteria search.

[edm-temp]

I am having trouble figuring out how to create a search function in excel that will allow for a user to enter two criteria and then have the vb search accordingly.

Basically I have a massive 2 sheet data base filled with Employee numbers and Courses they enrolled in and the status of the course. I want the user to be able to input the employee number and then choose the course from a combo box. The VBA should then take the two values and return on a blank page the cases where the two match and the Outcome.

Enumber is column A
Course is column C
Outcome is column E

User enters A and C and A, C, and E is output on the blank worksheet. There may be multiple cases where there are more than one result in the case where they failed the course the first time and passed it the second.

Anyhelp would be appreciated.

[snb]

In F1 : first criterion
In G1: second criterion
first sheet name: "Blad1" (change into 'sheet1', 'feuille1', 'Seite1'...)
second sheet name: "Blad2" (change into 'sheet1', 'feuille1', 'Seite1'...)

this example is restricted to A1:A100; you can expand it to A1:A65000

Please Login or Register  to view this content.