Hi,

I've posted this before and was pointed to a website that did this, but used
named ranges, somthing I'm trying to avoid.

I have a spreadsheet with company names along the top row, with the contacts
for each company on the rows directly beneath each company name.

what I want is a drop down list to pick the company (easy enough) but then
another drop down to pick the contact from that company (hard bit).

So when you pick a contact you are limited to only the contacts for that
company.

I don't want to have to declare a range for each company, as I want it easy
for users to add there own companies and contacts.

Thanks