automatically show data entered on another sheet within the workbo

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?