ExcelBanter - Drop Down List

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Drop Down List (https://www.excelbanter.com/new-users-excel/75956-drop-down-list.html)

Kerry Anne

Drop Down List

I am trying to insert a drop down list in one worksheet. I have a list of
names on worksheet 2 that I would like to drop down. The directions from Help
are hard to follow and there seem to be missing steps. HELP

Ron Coderre

Drop Down List

See Debra Dalgleish's website for good instructions:

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

Particularly, the "Name the List Range" section

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Kerry Anne" wrote:

I am trying to insert a drop down list in one worksheet. I have a list of
names on worksheet 2 that I would like to drop down. The directions from Help
are hard to follow and there seem to be missing steps. HELP

All times are GMT +1. The time now is 04:15 PM.