Hi Mark,

I don't use Excel much, so I can't really give a lot of help with the validation list issues. That said, I think your requirements for A7 can be met by using a separate column with just one entry per company.

FWIW, I'm attaching a workbook that uses validation plus a macro to clear a dependent dropdown so that you won't get invalid results.

Attached Files

Dependent Dropdowns.xls (241.0 KB, 12 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]