Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |