See reply in other NG(excel.misc). Please don't post to more than one NG.

"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