drop down list
 

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.

drop down list
 

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.

--
Thanks,
Shane Devenshire


"Sheryl" wrote:

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.