Can anyone help me, I want to be able to type a nem in one cell and be able to click search and it will look up an tell me where that name is in a particular Colum, like th e search feature but so that it will show only that name on the sheet, then I can press reset or something simular and the sheet will go back to all names.

Is this possible at all??

Shazz