Thanks Max, works great!

"Max" wrote:

DV = Data Validation (droplists)

1. DV created in C2 down to select Frequency: Monthly, OneTime
This DV is created via selecting the range, say C2:C10, then clicking Data
Validation, Allow: List, Source: Monthly, OneTime (Manually typed)

2. DVs created in D2 & E2 down to select "Begin MthYr" & "End MthYr",
using defined Name: MthYr, Refers to: =z!$G$1:$R$1

First, create the defined name via clicking InsertNameDefine
Name: MthYr
Refers to: =z!$G$1:$R$1
Click OK

Then create the DV above via selecting the range, say D2:E10, then clicking
Data Validation, Allow: List, Source: =MthYr
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---