Hi, I am hoping someone is about to help me.....

I have a spreadsheet that has 22 columns, and a large number of rows that each represents a "Rule".

I need to create a user form that when populated can carry out a number of rule searchs, and return the results to another worksheet using VBA.
Below shows an example of the fields in my form and the type of data it may contain....

Material Number - "12345"
Manufacturer - "WYS"
Product Line - "ELA"
Main Class - "A"
Marketing Code - "NEW"

From this it then needs to carry out the following searches and return each of the results a new worksheet called "Rule Results". Potential for some of the rules there may be no rule matches, and there just needs to move on to the next search.

- Material Number
- Manufacturer & Marketing Code
- Manufacturer
- Manufacturer & Product Line
- Product Line
- Main Class


Many thanks in advance.