Search box possibilities

I am questioning if it's possible to create a search box on sheet1 for example, type in a reference number then when clicking Search it takes you to the sheet that contains that reference number?

The reason for this is I am wanting to share some inventory data with our IT Service Desk and to allow them the ability to search and find the inventory stock at the click of the button is invaluable. I know the Find & Select feature already offers this but I'm looking for a sexier way of performing it.

Any thoughts?

Thank god, I hoped there was.

Any chance of that snippet of information on how to do it?

Absolutely perfect I can play with this and make it my own. Really appreciate the assistance.

enter middle line of code into your code....will look at if doesnt exist

Please Login or Register  to view this content.

Add the changes into sinteks code

Please Login or Register  to view this content.

@ sintek

Much tidier solution

Thank you both so much, this works a dream.