Excel 2003 search functionality ?

[FloppyPoppy]

Hey there guys, Have been in a new job for a little while now and have decided it's that time to make myself a spreadsheet to make my own job easier. This is just to benefit myself and not the company.

I have previously done some stuff in MS Access with similar results however wanted to keep it as simple as possible and stick in excel. The PC i have at work is to say the least.. an artefact of a age gone past. And is currently operating with XP & Excel 2003.

Here is a snip of my sheet so you have an idea of what i am doing.

Now at the top of this sheet (where it specifies space reserved for search functionality) I would love to have a input box and a search button.

Something like this.

What i want to do with this is be able to type in the product code ( will only ever be the product code ) and search, upon pressing the search button i want to see only the product row matching the code i have put in.

I am really not a fan of this style of conditional formatting

As i still find myself searching for what i wanted to find in the first place. Yet it seems to be one of the only methods i can find for 2003.

Do any of you Excel masters have any advice for me? I have been trying to do this for a couple of days now and have near enough given up but the function would be tremendously useful especially when the sheet is fully populated.

I would really appreciate any advice i receive, Sorry if i reply slowly, i work nights so hours are skew-whiff

 

[FloppyPoppy]

A fair point regarding filtering. I should have mentioned that I have tried that and it has one draw back, you can't search in it and the text is like font size 3 so completely illegible thanks grrrr will give it a go

 

[FloppyPoppy]

Sorry for the late update, you are right James that the text size is that size due to the zoom however we currently have a tiny resolution monitor so to get any useful amount of information into one page it needs zooming out sadly.

Ctrl+f whilst it does work it merely goes to the box containing that information, as there is a relatively large amount of information on the screen it would simply be easier to not see the other stuff.

Grrrrr, I have finally found a moment to implement and test your code and after a few small changes and workarounds with the older system it works an treat! I will get a copy of what I changed for you in the interest of knowledge.

Can't thank you enough for the assistance, top bloke!