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

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

"Akhil" wrote:

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