I want to acheive the following…
- if you select "daily" in B2, the in B4, the Drop down / Data Validation selections will be Mon / Tue / Wed / Thu / Fri
- if you select "weekly" in B2, the in B4, the Drop down / Data Validation selections will be 1 / 2 / 3
- if you select "Monthly " in B2, the in B4, the Drop down / Data Validation selections will be M / Q
- if you select "daily" in B2, the in B4, the Drop down / Data Validation selections will be Mon / Tue / Wed / Thu / Fri
- if you select "weekly" in B2, the in B4, the Drop down / Data Validation selections will be 1 / 2 / 3
- if you select "Monthly " in B2, the in B4, the Drop down / Data Validation selections will be M / Q