dependent validation

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Can I have validation in two or more columns that changes
the choice based on validation in column before. Simple
example is Column A has three cities, column b has
addresses. If you choose City1 in data validation in cell
in column a the choices in column b are then only the
addresses in that city, i.e. City1Street1-3, if I choose
City2 then the street choices are from a different list.

Thanks
 
Bill,

I have a workbook that provides dependent dropdowns like this, with a Data
Validation version and a combobox version.

Want a copy?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Bob,

I would like to have a copy of your workbook. Please can you forward it to
me.

Thanks
Andy
 
Hi Debra,

I followed your advice and it works. However, I just wonder why it does not
work with dynamic range name. Can you explain.

I've learned a lot from your website, THANKS.
Andy
 
Hi, Bob--

Saw your note about a sample file with combo boxes and/or dat
validation dependent lists and wondered if you wouldn't mind sharing i
with me.

I am trying to create a list of quota categories and thei
corresponding TSUSA #'s.

I have attached a file as an example and was hoping you would tell m
if your file will adapt to this set of criteria.

I look forward to your reply.

Thanks

Attachment filename: tsus-quotacat-descriptionsrevised12-9-03.xl
Download attachment: http://www.excelforum.com/attachment.php?postid=39754
 
Hi,

Had a look at your file, and from what I can see you seem to have 3 lists,
the type, the fibre, and then the items. My code only has 2, it could be
adapted, but I haven't had a need yet.

Also, it is simply lists, so all of the extraneous data, such Quota
Category, THUS #, would need to be held as well, and looked up.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks for taking the time, Bob.

Hopefully, I'll have a brainstorm when I lay my head to rest tonight!!

Thanks again,
soopia
 
I have a workbook that provides dependent dropdowns like this, with
Data
Click to expand...
Bob, I would like to see your version of the dependant combobox. Her
is what I have.

I have a purchase request form that I have entered all approved vendor
into a data sheet. I have a combobox on the master sheet that reflec
these vendors with the linked cell on the master.

Ok, here is where I get into trouble.
When someone select a vendor I would like it to change the contents o
about 10 other comboboxes. These 10 comboboxes are to list the item
that are specific to the chosen vendor. I have tried this wit
validation but have not gotten it to work at all.

Thanks for any help :)
Clayto
 
Back
Top