ComboBox on Multiple Cells

If you are creating 600 combo boxes you are doing it wrong.

Why are you using a combo box exactly? What are you doing with it? it would probably make sense to post a sample workbook.

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 then scroll down to Manage Attachments to open the upload window.

Thank you. I wasn't able to make a dummy sheet because of some formulas that weren't working but I got it now. Attached is what I am talking about. Cells B3-B5 are just a regular data validation list. However, with some many names that is hard to search. So in cell B2 I created a combo box so the supplier name would be searchable as well as populate the supplier group name using a formula. The desired result is how do I take what i have in B2 and apply that same method to all the blank cells so that if I enter something into B12 the combo box knows to put the corresponding supplier group name in cell a12 and so on? Does any of this make sense?

So the attachment in the workbook seems to work fine for me but I have NO idea what you are trying to do so I cannot help much.

I would suggest attaching a workbook and then asking for specific advice.

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 then scroll down to Manage Attachments to open the upload window.