Search Worksheet Using ComboBox & Show Results in Different Worksheet

Hi All

Heres hoping someone can point me in the right direction. I am trying to find a way of searching a worksheet ( Sheet1 for example ) which has hundreds & hundreds of rows of data entered into it from a userform. I would like to be able to search this worksheet using a userform with a ComboBox and command button and the results returned are shown in Sheet2 From Range A1:E1. Basicaly i am trying to turn the userform into a auto filter because there will be hundreds of duplicates in the combobox which is why i do not want to set the "ROWSOURCE" to column A if that makes any sense.

I have attached an example of what i am trying to achieve.

Thank you very much for the speedy response

That works perfectly and is exactly what i was trying to achieve. I don't fully understand how it all works but can make sense of some of it. Would i be able to do this by having a textbox where the user would make an entry and search ? ( or do i need to start a new thread )

Thanks again
regards MIFF3436

hi can some one help i have use this code for my project the only thing is diffenet i am searing by towns in the work sheet but every time i click on the town and click seach get an error message this part of the code not working

Please Login or Register  to view this content.

in my data i am doing a search using town eg Stafford, in my list are in vendars that bace in Stafford i would like it goto sheet 2

thank you