Microsoft Excel: How do I set the dynamic Data Validation in sh1:colB, when the dropdown list shall be based on data in sh2:colA-R? cells in sh1:colA are dynamically validated by sh2:A1-R1, while sh1:colB shall be dynamically validated by sh2:A2-R20.
-
Excel dynamic validations
-
Answer:
Could you provide a little clarification, what sort of data validation etc? Also would be easier to understand the issue if you use example data. For example BMWs are available in red and blue, Mercedes in blue and green; column 1 is cars, column 2 is colours and I want to make sure you can only select colours in which the cars are available etc.
Ash Patel at Quora Visit the source
Other answers
You probably need to organise your data a little different. I've written about dynamic data validation (drop-down list) in my blog - maybe that could be helpful: http://exceliseasy.wordpress.com/2012/10/15/create-a-dynamic-drop-down-in-excel-in-5-minutes/
Audun Danielsen
Related Q & A:
- How can I set up Yahoo in my Microsoft Outlook?Best solution by Yahoo! Answers
- How do I set up Yahoo mail on Microsoft Outlook?Best solution by Yahoo! Answers
- How can I set up my computer to alert me when I get an incoming email?Best solution by Yahoo! Answers
- How do I set up my Microsoft Outlook with my regular Yahoo email account?Best solution by answers.yahoo.com
- How can I set up my yahoo account to microsoft outlook express?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.