Hi

I assume you start on sheet Sheet1.
Select cell A1 on Sheet1
Data.Validation.List with Source='Monthly,Quarterly'
Select a value for A1

Add a sheet, p.e. Options
A1:A12 insert months
B1;B4 insert quarters
Insert.Name.Define:
define a named range p.e.
Period=IF(Sheet1!$A$1="Monthly",Options!$A$1:$A$12 ,Options!$B$1:$B$4)

Select cell B1 on Sheet1
Data.Validation.List with Source=Period
It's all


Arvi Laanemets


"CiaraG" wrote in message
...
Morning All,

I have a cell, where depending on the result of another
cell, I would like one of four drop down lists to appear
for the user to make a selection.

Example:

If Cell A1=Monthly then Cell B1 will contain a list of
months to choose from. If Cell A1="Quarterly" then Cell
B1 will contain four quarter months.

Any ideas?