Blackie50
04-13-2010, 04:45 AM
Hi,
Can anyone help with following
I have a number of short codes in a drop down list on sheet1 and would like the long code to be displayed on sheet2 in a related cell e.g.
A1 (sheet1) = Hi (short) on A1 (sheet2) Hello (Long)
A1 (sheet1) = Lo (Short) on A1 (sheet2) Lollipop (Long)
Also is it possible to have the dropdown list display all possible values instead of having to scroll down?
many thanks
Jon
Can anyone help with following
I have a number of short codes in a drop down list on sheet1 and would like the long code to be displayed on sheet2 in a related cell e.g.
A1 (sheet1) = Hi (short) on A1 (sheet2) Hello (Long)
A1 (sheet1) = Lo (Short) on A1 (sheet2) Lollipop (Long)
Also is it possible to have the dropdown list display all possible values instead of having to scroll down?
many thanks
Jon