How do you use a dropdown menu to enter data in mult. cells exce?
 

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.

How do you use a dropdown menu to enter data in mult. cells exce?
 

If by dropdown you mean Data Validation, then name the range e.g. myrange, on
your other worksheet and in Data Validation select

Allow: List
Source : =myrange

HTH

"John Baylis" wrote:

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.

How do you use a dropdown menu to enter data in mult. cells exce?
 

John

Use Data Validation for in-cell drop-down for selecting an item and VLOOKUP
for filling in the other cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Wed, 7 Mar 2007 02:20:00 -0800, John Baylis <John
wrote:

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.

How do you use a dropdown menu to enter data in mult. cells ex
 

Thank you. The combination of Data Validation and the Vlookup fuction solved
my problem. John

"Gord Dibben" wrote:

John

Use Data Validation for in-cell drop-down for selecting an item and VLOOKUP
for filling in the other cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Wed, 7 Mar 2007 02:20:00 -0800, John Baylis <John
wrote:

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.

How do you use a dropdown menu to enter data in mult. cells ex
 

Thank you. The combination of Data Validation and the Vlookup fuction solved
my problem. John

"Toppers" wrote:

If by dropdown you mean Data Validation, then name the range e.g. myrange, on
your other worksheet and in Data Validation select

Allow: List
Source : =myrange

HTH

"John Baylis" wrote:

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.