View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
barnabyp barnabyp is offline
external usenet poster
 
Posts: 1
Default Excel Search Filter


Hi, I hope someone can help.

I have a list of 1,500 products in an Excel worksheet. If a custome
rings up and asks for a certain product (eg ZWF1242) I have to scrol
down the whole list to find the product and it's corresponding info.
It takes ages and is annoying.

Is it possible (using VB or otherwise) to create a search facility tha
allows me to type the beginning part of the code (eg ZW) and as I a
typing the list of 1,500 products automatically reduces to all th
relevant products starting the with the same numbers or letters.
Obviously as more of the product code is typed in, fewer matchin
results are shown. I would like the filtering to be done

Is this possible to do? If so, how, my knowledge of VB is -very
limited!

If anyone knows, please contact me by replying here or emailing me a
.

Thank you very much.

Barnaby Partridg

--
barnaby
-----------------------------------------------------------------------
barnabyp's Profile:
http://www.excelforum.com/member.php...fo&userid=2736
View this thread: http://www.excelforum.com/showthread.php?threadid=46886