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