Connecting of two data validating with each other

[Akhil]

hi,

I have two drop down menu using data validation in excel which are as
follows:


1-Month 1
3-Month 3
6-Month 6
9-Month 9
12-Month 12


I like to automate drop down menu in such a way that once i select
1-Month the second menu automatically select 1. and same with rest of
others like once i select 12-Month in first menu the second menu become

12 automatically.


Thanks in advance for ur advice and help..


Regards,
Akhil Malhotra

 

[Guest]

Why have two? The first one doesn't add any obvious value but if you want to
continue with two look at:

http://www.contextures.com/xlDataVal02.html