Dynamic drop-down lists based on an initial value selection

  • Thread starter Thread starter Scott K
  • Start date Start date
S

Scott K

I need to be able to dynamically set the valid range of selectable values in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box (using
Data>Validation), I need the cell to the right to restrict its possible range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.
 
Glad we could hellp, Scott.......Thanks for letting us know.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

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

Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filling Out Cells Based on Data Validation 1
Data Validation with dynamic ranges 2
Assign numerical value to cell based on selection from drop-down m 1
Change drop down list in one cell based on values in other cells 2
Customise drop down list validation 3
Array Substitution Based on Drop Down List 1

Back
Top