Using dropdown boxes in Excel

[mag007]

Hi:

I have an excel question, I have 2 sheets in a document (xls). Sheet1 contains "contact information", and Sheet2 contains "Items to do".

On Sheet 2, I would like to have a dropdown menu of all the contacts in a cell. So, for each task I can select who needs to do what. How is that possible?

TIA

 

[xlbo]

Have a look at Data>Validation and choose the "List" option

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Rofeu]

When you want use a list that's on another sheet, put it in a named range (i.e. Contacts) and reference the name in your validation. (=Contacts)

Cheers,

Roel

 

[NYFashionToGo]

Here is a website that will give you a more visual approach of what needs to be done to create drop down menu's. I have found this very useful and easy to understand.

http://www.contextures.com/xlDataVal02.html