Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating data from a pull down
How can you populated columns of data on a worksheet from a pull down list
when the columns of data are on another worksheet? Can you populate a pull down list from a selection from another pull down list? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating data from a pull down
On Apr 29, 2:59*pm, Excel Help <Excel
wrote: How can you populated columns of data on a worksheet from a pull down list when the columns of data are on another worksheet? *Can you populate a pull down list from a selection from another pull down list? Add a named range. To do this go to insert/ name/ Define. Then once it is defined you can use Data/ validation/ List Source as =Name. Then your list can be on any sheet. It can also be column headings. You can even have the list be based on multiple named ranges. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a Data Validation List | Excel Discussion (Misc queries) | |||
Populating multiple cells from a single pull down | Excel Discussion (Misc queries) | |||
populating spreedsheet with data from access | Excel Worksheet Functions | |||
Populating Data and Looking Up Info. | Excel Worksheet Functions |