Need Help to Create a drop-down list from a range of cells.

**badger50** · 12-04-2006, 08:35 PM

Create a drop-down list from a range of cells. ?
HAVE FOLLOWED THE HELP. BUT DOES NOT WORK
AM I DOING SOMTHING OUT OF SEQUENCE ?

In workbook "sheet2"
From A1 to A7 I have Monday to sunday
I highlighted these 7 fields and defined the "NAME" for the list as "=weeks"
(no quotes)

I then went to
"sheet1" and I select the field in which I want the dropdown selection

On the Data menu, i click Validation, and then click the Settings tab.
In the Allow box, click List.
To specify the location of the list of valid entries, I did the following:

The list is on a different worksheet in the same workbook , so I entered the name that I defined (=weeks) for my list in the Source box.

I then get a message, THE NAMED RANGE YOU SPECIFIED CANNOT BE FOUND.

Any help please

**protonLeah** · 12-04-2006, 11:34 PM

Try:
Select the cells on sheet2 that hold the weekday names.
In the NAME box at the end of the formula bar, it should say A1.
Replace the A1 with "weekdays" or some other name (no = sign!)
Back on sheet1, select the cell in which you want the dropdown list.
Data>Validation>List,
then in the source box type "=weekdays" (with the = sign).
done.