VBA code to search using userform with multiple combobox's

Hi,

First post so hopefully i get this right.

I've created a Userform with multiple combobox's, what i would like is the user to populate all or some of the fields in the userform, hit search and the results displayed in another worksheet. For the fields that are not populated all values in the associated column would be included in the search criteria.

The entire row(s) of the search result will need to be copied and the pasted into a new sheet.

Hope this makes sense, i've attached a sample of the document.

Any help, or ideas would be appreciated, been stuck on this one for a while.

Regards Corey