Auto search/sort in Excel, or possibly Access

[liquidone]

I have a spreadsheet that I pull from quickbooks that has all our inventory items information. About 3000 items with 10 or so columns each. I need my sales guys to be able to find the items they need for jobs quickly. I want there to be like a search box that allows them to type what they are looking for, and it will sort the list down to what they are looking for after each keystroke. Kind of like the way most ajax websites are doing it, and the indexed search in outlook 2007. I am a programmer, but I dont know visual basic or vba almost at all. Is there an example of this already made, or a program I could buy to make this effect?
Thanks in advance,
Mike

 

[PHV]

In ms-access you may play with the AutoExpand property of a ComboBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886