List Dependencies
Please disregard my post, I misread yours.....my appologies!
Regards
Jean-Guy
" wrote:
Hi,
I'm hoping someone can help me.
I have two dropdown lists and for each element on one list I have a
corresponding element on the other list. When the user selects an item
from list one - I want to automatically populate the second cell with
the corresponding element.
Example:
A 10
B 20
C 30
D 40
E 50
So when user picks 'B' from the first drop down list. The adjacent cell
changes to '20'
Do I need some VBA or is there a simpler solution?
Thanks in advance,
Vinnie
|