J
John Baylis
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.
another work sheet to fill in multiple cells.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do you use a dropdown menu to enter data in mult. cells exce?
T
Toppers
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
your other worksheet and in Data Validation select
Allow: List
Source : =myrange
HTH
G
Gord Dibben
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
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
J
John Baylis
Thank you. The combination of Data Validation and the Vlookup fuction solved
my problem. John
my problem. John
J
John Baylis
Thank you. The combination of Data Validation and the Vlookup fuction solved
my problem. John
my problem. John