I have created a drop down list and need to know is it possible to have the
data selected from the list shown automatically on another sheet within the
workbook?

If you are using a control, in the "Format control"-Control tab you can fill
the Cell link textbox with the cell you want the value in.
If you are using data validation, a simple reference (=Sheet1!A1) will do.

Hope this helps,
Miguel.

"leah" wrote:

I have created a drop down list and need to know is it possible to have the
data selected from the list shown automatically on another sheet within the
workbook?

Thank you this has really helped.

"leah" wrote:

I have created a drop down list and need to know is it possible to have the
data selected from the list shown automatically on another sheet within the
workbook?