Make both row and column absolute.

Source $AT$1:$AT$13

Better yet, select your list range and insertnamedefine

Give it a name.

In DVList source enter =thename

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


Gord Dibben MS Excel MVP

On Wed, 13 Jan 2010 15:18:01 -0800, bmd857
wrote:

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!