Thank you Conan ~ that's exactly what I needed. One more question ... I
tried to copy and paste to the following rows and the formula was
automatically changed from A1 to A2, A3, etc. How can I keep the formula a
constant when copying?

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1 to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you! :)