Populating data from a pull down

[Excel Help]

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?

 

[jlclyde]

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