automatically show data entered on another sheet within the workbo

L

leah

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?
 
M

Miguel Zapico

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.
 
Top