drop down lists
 

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!
--
bmd

drop down lists
 

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!

drop down lists
 

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.

"Gord Dibben" wrote:

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!

.