how to write a dependent validation with all numbers

M

mark.campsey

need to place a value in A1 and have an associated drop down menu auto placed in A2?
 
Z

zvkmpw

need to place a value in A1 and have an associated drop down menu auto
placed in A2?
Click to expand...

Here's one way.

Put the values for the drop-down lists in consectuive columns someplace; for example,
H1:H7 for A1=1
I1:I10 for A1=2
etc.

Then use
Data > Data tools > Data Validation > Data Validation
and in the dialog box choose
Allow: List
Source: =OFFSET(G1,0,A1,COUNTA(OFFSET(G1,0,A1,10000,1),1))
and fill in the remaining DV settings as desired.

If the A1 values are other constants (that is, if they aren't the counting numbers 1,2,3,...) first use MATCH(A1,...,0) with a list of the allowed A1 values to get a counting number for the Source (in place of simply A1).

Hope this helps getting started.

(I have Excel 2010.)
 

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

drop box/data validation help 0
Drop down list control value in vba 2
VBA Coding Help for Beginner 0
Help with drop down selection and populating related data... 9
How to make repeating drop-down lists? 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Multi-level dependent data validation 3
Paragraph numbering in Word 1

Top