Populating data from a pull down

  • Thread starter Thread starter Excel Help
  • Start date Start date
E

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?
 
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?
Click to expand...

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
 
Back
Top