Excel 2003: Adding dropdown list into column fields 2

[boaconstrictor]

Hi, I have a table with several columns (Name, industry, leadsource, etc). The data will be filled in through other persons. In order to keep the data in the column "industry" consistent, I would like to add dropdown lists into the fields of this column.
Does anybody know how this could be achieved?

Thanks alot

boa

 

[SkipVought]

Hi,

Take a look at Data/Validation - List.



Skip,

_[red][/red]

 

[ThomasLafferty]

Sure! Take a look at data validation. If you have a lengthy list, here's what I would recommend.

1. Type the list into a 1 column wide table somewhere in your workbook, one list item per cell in the table column.
2. Select the entire list and give it a name. Insert>Name>Define>Names in workbook>[!]YourName[/!]
3. Select the cell or cells where you want to use a dropdown.
4. Click Data>Validation>Allow>List
5. In the source box, type [!]=YourName[/!]
6. Make sure In cell dropdown is check.
7. Click OK.

Voila!

Hope this helps...

Tom

Live once die twice; live twice die once.

 

[firefytr]

For a dynamic list, check out these links ...

http://www.theofficeexperts.com/forum/showthread.php?t=4717&page=2

http://www.mrexcel.com/board2/viewtopic.php?t=88715&highlight=&sid=d5c73c6ecc2c1b0aabd36ec28dbc9bf0

http://www.mrexcel.com/archive2/75100/87123.htm

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenWright]

Also, if you want your list to reside on a different sheet to that of the Validation cell{s} itself, you need to name the list and then use the name preceded by an '=' in the 'refers to' box when you set up the validation.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[arthurbr]

If your column is already populated, there is also the "Pick from dropdownlist" option when you right click a cell of this column.

Cheers
André

 

[KenWright]

I should have clarified actually, my reply gives you the same method as Thomas' reply, but what I was trying to get over was the fact that whilst this is not the only way to reference a DV list, it is in fact the ONLY way to do this when the data is on another sheet.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------