| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
