You're welcome! Glad you got it working.

There's a limit to what you can enter in the Source box of the Data
Validation dialog box, so it's usually easier to refer to a list on a
worksheet, or a named range. In this case, the delimited list works better.

The separator that you use will depend on your regional settings. Here
in English Canada it's a comma, and in other places it's a semi-colon.

Buckie wrote:
SUPERB! It works (I used method 2). The clue apparently is not to use a
column with values to define your drop down list (which is the standard way
proposed by excell "help" :-s ) but to add the values directly in the
"source" box (I did not know this was possible, is much easier). Just one
remark for others trying this: you have to seperate the list options with ;
not with , .

Thanks very much Debra!!

"Debra Dalgleish" wrote:


There are two separate solutions that I suggested. The cells with the
drop down lists should have General or Number format.

1) In ToolsOptions, change the reference style to R1C1
Select the cells where you want the data validation drop down
Choose DataValidation
Allow: List
Source: Deceased, Retired, =TODAY()-RC3

2) In ToolsOptions, turn off the R1C1 reference style
Select a cell in row 2
Choose InsertNameDefine
Name: Age
Refers To: =YEAR(TODAY())-YEAR(Sheet1!$C2)
(use your sheet name instead of Sheet1)
Click OK
Select the cells where you want the data validation drop down
Choose DataValidation
Allow: List
Source: Deceased, Retired, =Age




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com