Connecting of two Data Validation with each other

  • Thread starter Thread starter Akhil
  • Start date Start date
A

Akhil

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting of two data validating with each other 1
Like Data Validation BUT 2
Aging Report 4
Data Validation using Unique Values 2
Can I Change Displayed Data Through Data Validation? 4
Add 0 before month 1 to 9? 7
Excel Drop Down List 3
Excel Drop Down Menu linked? 6

Back
Top