Page 1 of 1

Need some help with Excel

Posted: 2009.06.10 (07:30)
by wedgie
Ok basically I have a worksheet containing a load of data in a sort of table/list type thing like this:
untitled.PNG
If I click on the company name tab and go 'text filters>contains', and then type something in, then it will return any records in my table that contain what I've typed.
What I'm trying to do, if possible, is just shorten down this method into a search box of some sort. I just want to be able to type what I want to search for into a box at the head of the table and then have this perform the same sort of lookup filter that the original way did to return the search results.
I've searched around loads trying to find this out, but I just keep finding answers that involve visual basic and all types of coding that I just can't get my head around.
Any help would be greatly appreciated.

Re: Need some help with Excel

Posted: 2009.06.10 (17:20)
by t̷s͢uk̕a͡t͜ư