Variation on dependant Lists problem

  • Thread starter Thread starter andyp161
  • Start date Start date
A

andyp161

Hi,

Is it possible to programme Excel so that if you enter a particula
value in A1 it will enter an associated text in A2. For instance, I a
trying to create a stock-control sheet. Each piece of stock has a cod
and a description. I would like to be able to enter the code in colum
A, which will automatically enter the description in column B. I kno
how to create dependant lists using data validation and wondered i
there was a variation on this function that would solve my problem.

Many thanks

And
 
Back
Top