| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter postccripts in an Exce, such as for powers of a nu | Excel Worksheet Functions | |||
| In Excel how do I set up the list from the Data dropdown menu? | Excel Discussion (Misc queries) | |||
| I can not find the list command from the data dropdown menu? | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| how do I enter more data to an already made pull down menu | Excel Discussion (Misc queries) | |||
Linear Mode
