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?

automatically show data entered on another sheet within the workbo
 

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?

automatically show data entered on another sheet within the workbo
 

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?