I am not very familiar with creating Userforms and also Macros. My knowledge with macros are very basic.

Here is my project. Column A is a list of suppliers. Other columns are data pertaining to the suppliers like Agreement #, Spend, etc. I need a search box where users can enter in a supplier name and Excel will find matches. So if I type in "Inc", I would hope that there would be a result table that would show all the suppliers on the list that has "Inc" in it. Then the user can select one of the suppliers in the result table and it will refresh a second worksheet with just that supplier's data.

Is this possible?

Thanks for your help!