Hi, I'm trying to do a validation on 1 cell, what I wan to achieve is when we
type the first letter or number of the info the cell can bring me the the
first item it got and show me the rest, I know that XL 2007 can do it, is it
a way to do it on XL 2003?

Thanks for your help

http://contextures.com/xlDataVal10.html

I believe this will give you the feel you want.
--
** John C **


"Ch. G." wrote:

Hi, I'm trying to do a validation on 1 cell, what I wan to achieve is when we
type the first letter or number of the info the cell can bring me the the
first item it got and show me the rest, I know that XL 2007 can do it, is it
a way to do it on XL 2003?

Thanks for your help

Thanks for the help I'm novice in XL this look like I have to create a macro
and I'm not use to that, I need this information because I create a form for
the quote we have 14K item, when we are looking for a item it can be long, I
includ a new sheet with all the item so they can do a search but with the
user that we have is a little difficult for them to to sheet to an other that
why I try to find out a way to do a drop down I will read the contexture very
carefully to see how it can help me.

Thanks again for your help John, I will wright you back to see if it work or
not.



"John C" wrote:

http://contextures.com/xlDataVal10.html

I believe this will give you the feel you want.
--
** John C **


"Ch. G." wrote:

Hi, I'm trying to do a validation on 1 cell, what I wan to achieve is when we
type the first letter or number of the info the cell can bring me the the
first item it got and show me the rest, I know that XL 2007 can do it, is it
a way to do it on XL 2003?

Thanks for your help