Connecting of two Data Validation with each other
 

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

Connecting of two Data Validation with each other
 

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