Populating data from a pull down

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?
 
J

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?
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull corresponding data from drop down list 2
Pulling info referencing another column 1
Pull-down List 2
How to create a pull down lists? 1
Can the dwnarrow box for a pull-down list be on the left? 1
Check for duplicate entries in pull-down list 1
Excel 2007 Pull Down List 5
Using a Drop Down Menu 1

Top