drop down lists

[bmd857]

how do you link a drop down list in one column to a range of cells in another
column. list is in at1-13, the column i need the drop down is u1-u899. I
tried to copy it from one cell to all the others but that did not work. my
source on the list is as follows; $at1:$at13. can't figure it out. please
help!

 

[Gord Dibben]

Make both row and column absolute.

Source $AT$1:$AT$13

Better yet, select your list range and insert>name>define

Give it a name.

In DV>List source enter =thename

Now you can use that list on other sheets if you wanted.


Gord Dibben MS Excel MVP

 

[bman]

Gord,

You select the column or range of cells, then pick

DATA|VALIDATION menu
When the dialog box opens select SETTINGS and under ALLOW, Choose LIST and
insert the set of data cells ($AT$1:$AT$13) the you want.

the Excel help menu describes this. Search for "drop-down".

The other reply to your post may do as well also, esp for use on other
sheets. Haven't tried it.