adding data from one sheet to another sheet as a dropdown list bo.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add a drop-down list box on a seperate worksheet that my data is on
 
On this other sheet that holds your data, select the range that you want to
use in the Data Validation list and name it via Insert - Name - Define and
type in the name, like "MyList" without the quotes.
Then in the cell where you want the Data Validation cell, click Data
Validation, select List, and type "=MyList" without the quotes. Done. HTH
Otto
 
You must log in or register to reply here.

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

Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Copy dropdown list 1
Filtering 2
Filtered drop down list 2
Data Validation Dropdown List Not Working 4
Possible VLOOKUP ? 3
Help with lists please 3
Excel Move or Copy Stopped Working? 0

Back
Top