Search using multiple criteria within userform and display all results on another sheet

Hello,

I have a table with 7 columns of data (A to G) on the "Data" sheet that I would like to be able to search for strings of text using criteria from any one of the columns or any multiple of columns. I would like to be able to enter the criteria in a userform and get the results on the "Search" sheet. The results should contain all the data from the row that contains a match. The "Search" sheet should also be cleared except for headers before results are dispalyed. I have this working at the moment using a textbox but can only enter one criteria which searches the entire workbook and gives the results from all sheets. This pulls up too many matches I would like to be able to use multilple criteria to filter what I need to see and only search the "Data" sheet. I have attached a workbook to give you an idea of what I have. The workbook uses a userform to enter the data via dropdown lists and textboxes.

Thanks

Tony

You could really extrapolate this into a menagerie with the type of data you are trying to search and the possible duplications that can occur. I would suggest that you add a column to your table for serial number which would give you more of a chance to search for a unique value. If you have to use more than one criteria, you could use a loop or autofilter to narrow the choices. I wouldn't want to try it with the current data.