Not sure Debra. My work around for now is one list and then reference
different cell range in validation. Appears to be working so far.
"Debra Dalgleish" wrote:
The instructions Max gave you are for items lists on the same sheet as
the dropdown lists.
If you want to use different dropdown lists in multiple columns, it's a
good idea to store the item lists on a different sheet. Then, name the
lists, and refer to the names in the data validation dialog box, as
described he
http://www.contextures.com/xlDataVal01.html
Maybe the advice you saw suggested storing each of the source lists on a
separate sheet.
Techno Grandma wrote:
Thanks Max. I read it is not advisable to have more than one of these lists
per worksheet. Is this correct or could I have several columns with drop
down choices?
"Max" wrote:
Suppose your words list is in say: A10:A12
Select A1 (or select the range, say A1:A3)
Click Data Validation
Allow: List
Source: =$A$10:$A$12
Click OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Techno Grandma" wrote:
I have a table with a column I want to let the user choose from a list of
words to fill the cell. I have made a list of the words on my worksheet
below my table. How do I get the drop down list to happen in the column.
Thanks
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html