Can I access a list of names from somewhere other than a
list above the cell I am trying to populate?
I want to be able to select a name from a list to speed
up input, but I don't have room for the list above the
name cells.
Any help would be greatly appreciated!
TK

Use data validation
http://www.contextures.com/tiptech.html
You can put the list on another worksheet by naming it and referring to the
name in the validation.
--
Don Guillett
SalesAid Software

"Tom Kavanaugh" wrote in message
...
Can I access a list of names from somewhere other than a
list above the cell I am trying to populate?
I want to be able to select a name from a list to speed
up input, but I don't have room for the list above the
name cells.
Any help would be greatly appreciated!
TK

Hi
see
http://www.contextures.com/xlDataVal05.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom Kavanaugh" schrieb im Newsbeitrag
...
Can I access a list of names from somewhere other than a
list above the cell I am trying to populate?
I want to be able to select a name from a list to speed
up input, but I don't have room for the list above the
name cells.
Any help would be greatly appreciated!
TK

Tom

Use a Data Validation in-cell drop-down list.

The list can be on another sheet if you wish(as long as you name the list).

See Debra Dalgleish's site for more on Data Validation.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

On Fri, 14 May 2004 14:27:03 -0700, "Tom Kavanaugh"
wrote:

Can I access a list of names from somewhere other than a
list above the cell I am trying to populate?
I want to be able to select a name from a list to speed
up input, but I don't have room for the list above the
name cells.
Any help would be greatly appreciated!
TK