Multiple Selections Using Dynamic Lists

[Avery]

I have the following scenario:
ex:
I have a request for bid on a construction job that could have many
customers bidding.

My customer list is:

Column A - Mangolian Steel (Source is CustomerList)
Column B - Jeff Ransom
(Source=OFFSET(CustomerStart,MATCH(B2,CustomerColumn,0)-1,1,COUNTIF(CustomerColumn,B2),1)
Column C - Mangolian Steel-Jeff Ransom
(I need to be able to get multiple selections of the cocantenated customer
in column C)

Please help

 

[Alojz]

Hi, u need C1 showing Mangolian Steel-Jeff Ransom when A1 reads Mangolian
Steel and B1 reads Jeff Ransom?
Insert in C1: =A1&"-"&B1
another option: =concatenate(A1,"-",B1)

 

[Avery]

I have the concatenation part down. What I need is to be able to select
multiple customers-contacts for cell C1.

I have been unable to locate any code that could perform this task.

 

[Alojz]

Sorry, I don't understand.

I have the concatenation part down. What I need is to be able to select
multiple customers-contacts for cell C1.

I have been unable to locate any code that could perform this task.

 

[Avery]

I have a bid list that has multiple customers quoting each bid. Each customer
may also have a different engineer/contact in charge of that bid...so, I need
to be able to select the customer from a drop down, and select the contact
from the dependent drop down, and populate the concatenated customer-contact
in the next column, but my problem occurs with the need to have more than one
customer contact on any given bid.

Select: Select:
Customers(ex) Contacts(List only shows related Contacts for
Selected Cust.)

Mangolian Steel Jeff Ransom
Flax Steel Molly Marks
Japan Steel Si Maku

I need to be able to select multiple customers and contacts per instance.

 

[Alojz]

Still not sure if I unerstand u correctly, anyway, let me try.
Use data validation. Create lists. Major list will be company list. For each
company create dependent list of contacts. Label all lists. I do it in simple
way here:
CompanyList = companyX, companyY, companyZ
dependent lists:
CompanyX = contactA, contactB, contactC
CompanyY = contactK, contactL
CompanyZ = contactF, contactU

Apply data validation to column A, as a validation list use CompanyList.
Apply data validation to column B, inserting indirect formula to source box.

For exampe, for cell B2 I insert in the source box: =indirect(A2).
This will direct the selection to the particular company list.

If in A2 I select company Y, then in B2 my selection may be contactK or
contactL.

HTH

 

[Avery]

This part I already have, but I need to be able to select multiple
customers-contacts per instance.

 

[Alojz]

I really do not know what u mean then, I am sorry.

 

[Max]

.. need to be able to select multiple customers-contacts per instance

Try Debra Dalgleish's sample file at:
http://www.contextures.com/excelfiles.html

Under Data Validation,
look for: DV0017 - Select Multiple Items from Dropdown List

It's a very informative sample
where several techniques are illustrated in different tabs

Since you want the "multi-selected" subjects to be ... all listed in a cell?,
viz your line:

.. to be able to select multiple customers-contacts for cell C1

then a close fit might be Debra's example in her tab:
CommaSeparated

Celebrate it, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---