Use data validation with List option and point to Named ranges on Sheet2


and select the list from the corresponding column for each row.

See http://www.contextures.com/xlDataVal13.html

I don't think you need dependent lists... You just want to select, say
names, from Sheet 2 names column...

"RichW" wrote:

I need to be able to auto-fill a cell from a list on another sheet. First, is
this possible? Second, How do I do it? The second sheet has 30 some columns
each with 2 to 8 selections under a specific header. Under the same header
name on the primary sheet I would like to be able to select one choice from
each column. Hope I made that clear enough to comprehend my question.

Thanks.