G
gibbylinks
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
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