View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default 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?