Drop down list to fill information.

[brainkill3r]

Hello,

I have a sheet where I keep contact details, such as Company Name, Contact Person, Email, Phone Number and Address.

I also have different templates for example for a purchase order. I would like to make a drop down list where I will select the Company name (that exists in my sheets as "contacts") and based on the name of the company, to have all the cells with addresses and phone numbers fill in.

Is this possible? If yes, could you please give me some hints on how to do it?

Thank you!

[xladept]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[brainkill3r]

I have attache the file.

Thank you for your help. Please let me know if you need more information.

[xladept]

Here's your sheet back - it's just in the before sheet - try it and let me know:

[brainkill3r]

Here's your sheet back - it's just in the before sheet - try it and let me know:

It works! This is it!

Now I just need few days to understand how it works as for now, reading the code did not help.

I know a bit of coding but not that much, would you suggest anything to help me improve my skills? A website, some example, anything would be appreciated.

Thank you for your help!

[BellyGas]

Yeah, this one. Start here: https://www.excelforum.com/excel-pro...materials.html

[xladept]

You're welcome and thanks for the rep!


Here's commented code:

Please Login or Register  to view this content.

*The data validation was installed manually

[brainkill3r]

this is gold! thank you

[xladept]

You're welcome!

[brainkill3r]

I tried to add more items in it but it does not work with more data.This code is too much for me to understand.
It did the trick but now i need more items in it.

[xladept]

What do you need to add?

[brainkill3r]

What do you need to add?

More companies. If I add another company it is not in the list, I would like to add as many as I want and see them in drop down.

[Akuini]

Hi, brainkill3r

If your list is big, say more than 50, then I suggest you use a combobox instead of data validation.
The combobox would be able to search as you type (the list will be narrowed down as you type).
Here’s an example:

[brainkill3r]

This is good but id does not return values that would be on the on the same row, next to the value from drop down.

How can I add a command that would return the values from the same row where the one in the drop down is?

[Akuini]

Ok, try this: