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.

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.