Different need for a list

[Elmo Watson]

I need something like a List in Excel - but it's not technically for sorting
and I don't want it at the header line.

Picture a regular application with a Dropdownlist/combobox
This list has a lot of items in it, that I want to choose from on every line

So it's like this:
Header: Item -------------Column2Header----Column3Data
(choose from dropdown) - column2 Data- ---------column3 Data

I need to copy the dropdown on every new line, to choose from that list,
what's relative to the data in that line for Column2 and Column3

Any ideas on how this can be done (or if) in Excel?

 

[Dave Peterson]

Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html