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
|