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