Search Database with a gui from a Noob

[Brien.k]

Good Day

Basicly waht I want to do is create a GUI interface on the first sheet of the workbook that will give me the option to enter a certain detail of the client(i.e. Clinet Name, Client Surname, Contract Number etc.)
I already hav a sheet with all the detalis in rows with the coloms labeled.

When you press the search button it should display all the other information about the client below the search function.

I have no experience in creating macros etc.
So please I need all the help I can get.

I am using Excel 2007

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html