drop down list

  • Thread starter Thread starter Sheryl
  • Start date Start date
S

Sheryl

My question: I have two worksheets. One worksheet has several columns. The
second worksheet has one column. I want the information from number 2
worksheet to be in a drop down in a column on my first worksheet.
Thanks.
 
Hi,

You can use Data, Validation for this, but you must name the range in the
1st sheet that contain the items you want on the drop down in the second
sheet.

1. Select the range containing the items in sheet 1 then choose Insert,
Name, Define and type a name (without spaces) into the Names in workbook box
and click OK. Suppose you name it myList.
2. Move to sheet 2, select a cell or range and choose Data, Validation and
on the first tab pick List from the Allows drop down. In the Source box
enter =myList and click OK.
 
Back
Top