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

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