Help Me – Contact List 

I need help with auto-populating my contact list. I have tabs for master consultants and trades lists. Then, a tab for the working project list. I am trying to auto-populate fields on the working project list.

The problem lies where I have multiple contacts in a specific field, such as electrical engineer or flooring company. With the formula that I am using currently, it will only auto-populate the first person on the list. I’d like the option of being able to choose from the multiple company choices I have, but only when necessary. I like that I can auto-populate “architect” with a single button, as there is only one architect that we work with. But I don’t necessarily want to add dependent drop down lists to every row if I don’t have to. I hope that makes sense.

I am really new to excel, and searching Google and Youtube is failing me at this point, please help me! Thanks.

​Help Me – Contact List  I need help with auto-populating my contact list. I have tabs for master consultants and trades lists. Then, a tab for the working project list. I am trying to auto-populate fields on the working project list. The problem lies where I have multiple contacts in a specific field, such as electrical engineer or flooring company. With the formula that I am using currently, it will only auto-populate the first person on the list. I’d like the option of being able to choose from the multiple company choices I have, but only when necessary. I like that I can auto-populate “architect” with a single button, as there is only one architect that we work with. But I don’t necessarily want to add dependent drop down lists to every row if I don’t have to. I hope that makes sense. I am really new to excel, and searching Google and Youtube is failing me at this point, please help me! Thanks.    Read More

​