Dependent cell data validation

SoulSister

New Member
Joined
Apr 2, 2014
Messages
1
Hi, I have a visit schedule set up as a table. Visits are scheduled by quarter. I want to ensure, via data validation, that if cell C2 states 1 (ie Qtr1), that the visit date in D2 can only be between 01/04/15 to 30/06/15 (the dates in the quarter), if it's 2 then D2 can only be between 01/07/15 to 30/09/15 and so on for the other quarters. We currently have separate sheets in a single workbook and I need to bring them all onto one sheet. Hence the problem. Thanks in anticipation.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,109,461
Messages
5,528,939
Members
409,848
Latest member
Blomsten
Top