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, 14 views)

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

Yeah yeah yeah

I get it, awesome thanks for that, hmmmm so now all I really need to do is get time of day working, services I can mange well enough using an indirect with a separate column, but the time of day will be really hard if it can't look up the first 3 columbs to get its time of day part by itself