have a cell return one of severl lists based on data from another
 

I am creating a form and would like to automate it with drop-down lists.

Worksheet 1 has the data entry areas(cells) and the Data is on Worksheet 3
in several lists/ each with a "Name" .

I can have the first column on Worksheet 1 use validation to generate a list
for the product description what I need is for the next column on this sheet
to provide the appropriate drop down list that coincides with the entry in
column 1

Is this Possible?

See

http://www.contextures.com/xlDataVal02.html

In article ,
"d6j9s" wrote:

I am creating a form and would like to automate it with drop-down lists.

Worksheet 1 has the data entry areas(cells) and the Data is on Worksheet 3
in several lists/ each with a "Name" .

I can have the first column on Worksheet 1 use validation to generate a list
for the product description what I need is for the next column on this sheet
to provide the appropriate drop down list that coincides with the entry in
column 1

Is this Possible?

That was exactly what I needed.
THANK YOU!!!!

"JE McGimpsey" wrote:

See

http://www.contextures.com/xlDataVal02.html

In article ,
"d6j9s" wrote:

I am creating a form and would like to automate it with drop-down lists.

Worksheet 1 has the data entry areas(cells) and the Data is on Worksheet 3
in several lists/ each with a "Name" .

I can have the first column on Worksheet 1 use validation to generate a list
for the product description what I need is for the next column on this sheet
to provide the appropriate drop down list that coincides with the entry in
column 1

Is this Possible?