| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down List - insert row?
I have a table with the name in the first column and a series of numbers in
the remining columns. Elsewhere in the sheet I want to creat a drop-down list of names and when a name is selected, I want to bring the whole row of values forward. It is easy to bring the Name cell forward but I can't figure out how to bring the whole row. HELP??!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down List - insert row?
On Nov 4, 10:16*am, DianneB wrote:
I have a table with the name in the first column and a series of numbers in the remining columns. Elsewhere in the sheet I want to creat a drop-down list of names and when a name is selected, I want to bring the whole row of values forward. It is easy to bring the Name cell forward but I can't figure out how to bring the whole row. HELP??!!!! What do you mean by forward? Jay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down List - insert row?
Same as if I I did a COPY and PASTE and copied that whole row to the line
with the drop-down List. "jlclyde" wrote: On Nov 4, 10:16 am, DianneB wrote: I have a table with the name in the first column and a series of numbers in the remining columns. Elsewhere in the sheet I want to creat a drop-down list of names and when a name is selected, I want to bring the whole row of values forward. It is easy to bring the Name cell forward but I can't figure out how to bring the whole row. HELP??!!!! What do you mean by forward? Jay |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down List - insert row?
VLOOKUP function copied across as far as you want?
Assume your names are in column A1:A10 and numbers in B1:Z10 Dropdown in A11 In B11 enter =VLOOKUP(A1,$B$1:$Z$10,COLUMN(B1),FALSE) Copy across to Z11 Edit to suit your idea of a "whole row" Gord Dibben MS Excel MVP On Tue, 4 Nov 2008 08:52:01 -0800, DianneB wrote: Same as if I I did a COPY and PASTE and copied that whole row to the line with the drop-down List. "jlclyde" wrote: On Nov 4, 10:16 am, DianneB wrote: I have a table with the name in the first column and a series of numbers in the remining columns. Elsewhere in the sheet I want to creat a drop-down list of names and when a name is selected, I want to bring the whole row of values forward. It is easy to bring the Name cell forward but I can't figure out how to bring the whole row. HELP??!!!! What do you mean by forward? Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert drop-down list without existing cell info | Excel Discussion (Misc queries) | |||
| insert a drop down list if a certain cell value is true | Excel Worksheet Functions | |||
| How do i insert a Address Bar kind of drop down list within MS Exc | Excel Discussion (Misc queries) | |||
| How do I insert a drop down list in a cell using | Excel Worksheet Functions | |||
| How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions | |||
Linear Mode
