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

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

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

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