Control Box and Index

Henry

Board Regular
Joined
Mar 7, 2002
Messages
180
Hi: Let me see if i can explain this w/ot cause mass confusion. I am using Control Box, the one with drop down selection capability. I have a in A1 thru A10, meaning 10 boxes. The data that comprises the box is in a 2nd worksheet titled data. Each DD allows the customer to select from 150 different names. Each box has 150 names to choose from. So, once the customer selects 10 names, which in turn are placed in each respective cell using Index (same data worksheet), I then used Concatenate and pull all 10 names into one large cell. So A1 thru A10, using Control Box is tied to Index which in turns places the chose name in cells A1-A1-. Then I Concatenate A1-A10 into B1. Does this make sense. The real problem, besides mass inefficiencies, is I have to have 10 cocmplete sets of names (10 x 150) just to get the info into B1. Isn't there a cheaper, better, faster way of getting this done. My current method means lots and lots of data on my Data WS. Thanks Again.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,186,155
Messages
5,956,250
Members
438,243
Latest member
FXA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top