Need some help with Excel
Posted: 2009.06.10 (07:30)
Ok basically I have a worksheet containing a load of data in a sort of table/list type thing like this:
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.
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.