Search Entire Table?

[Necroscope]

Hi, I have a fairly standard table containing columns with office names, addresses, site codes, server numbers and contact names for each site.

I want to be able to have a search box that I can type a word into and have matching results returned. I can do this using formula to search one column (the office name field) but I want to be able to search ALL columns because - for example - if I were to type "London" in to a search field, I'd want all the London offices to be listed but some of these are mostly known by other names like "Victoria House" or "Alexandra Park". However, if the search looked at the address column too, it would find everything. Also, searching all columns would also help me if I knew a server number but didn't know the office that has that server. I could type that in and it would return the office name/address details too...

Ideally, I'd like a little mini table to show under the search box and have Office Name > Address > Site Code > Server Number > Contact name details.

I've no preference on whether this is done via formula, VBA, a Userform or something like that. The database is on one sheet and my current search attempt is on a separate sheet but I am happy to go with whatever is easier, if this is possible in the first place of course... Can anyone please help?

Thanks.

 

[Necroscope]

Hi Akuini.

That code works perfectly, thank you so much for taking the time to help with this; it is much appreciated.

 

[Akuini]

Hi Akuini.

That code works perfectly, thank you so much for taking the time to help with this; it is much appreciated.

You're welcome, glad to help, & thanks for the feedback.