Multiple Selections Using Dynamic Lists
 

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

Sorry, I don't understand.

"Avery" wrote:

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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" wrote:

Sorry, I don't understand.

"Avery" wrote:

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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 he
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" wrote:

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" wrote:

Sorry, I don't understand.

"Avery" wrote:

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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

"Alojz" wrote:

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 he
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" wrote:

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" wrote:

Sorry, I don't understand.

"Avery" wrote:

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

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

"Avery" wrote:

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

"Alojz" wrote:

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 he
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" wrote:

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" wrote:

Sorry, I don't understand.

"Avery" wrote:

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" wrote:

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" wrote:

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,CustomerColu mn,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

Multiple Selections Using Dynamic Lists
 

.. 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
---