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