automatically show data entered on another sheet within the workbo

[Guest]

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?

 

[Guest]

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.

 

[Guest]

Thank you this has really helped.