Search, Find & Show

Hello dear friends,

I created a table in Excel 2007 which contains some data in columns (such as First Name, Surname, Phone Number etc). The thing I need is to create a "Search Form" where the user will fill a letter, or exactly what he looks for (i.e. the First Name) and in another cells the rest of the details (Surname, Phone Number etc) will be showed.

So, to make it clear...

You type "o" in the search cell and bellow you see every name which contains the letter "o" with the rest of the details. IMPORTANT! I need to search for "o" in the First Name, the Surname, the Phone Number etc. Not only in the first name.

I am not sure if the right way to do it is through formulas or macros... I already tried some things but no luck!

Thank you in advance!

can you submit a copy of your workbook?

Example.xlsx

Thank you in advance for trying!

Try:

Please Login or Register  to view this content.