I have a table with company names on row 1 with contact names under each one.

I want to have drop down with the company names (Easy bit) but then another
drop down underneath with the contact names for that company.

I have defined a range "Company" for row A, but I'm trying to do it without
having to define ranges for each company. Is it possible ?

Thanks