adding new item in dropdown & using existing item as new record

**lui de sagun** · 10-04-2015, 10:52 PM

Hi,

Please help me with my problem - I need your expertise again:

In my userform is a Customer/Company Name dropdown. Values of this dropdown refers to CustomerName in Logs sheet. With these, I want to do the following:

1. New Customer should be added to CustomerName whenever a new data is added to Customer/Company Name dropdown.
2. I can be able to use the dropdown as a Search engine to verify if a certain customer name is already in the database.
3. On the same dropdown, I can also be able to create multiple records using an existing Customer name.

I tried to look from some of your samples, but nothing seem to work in my file

Appreciate your help please.

**skywriter** · 10-05-2015, 02:33 AM

Attach a sample workbook. 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 use the paperclip icon to open the upload window.

View Pic