Drop down List - insert row?

  • Thread starter Thread starter DianneB
  • Start date Start date
D

DianneB

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??!!!!
 
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 whena
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??!!!!
Click to expand...

What do you mean by forward?
Jay
 
Same as if I I did a COPY and PASTE and copied that whole row to the line
with the drop-down List.
 
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
 
Back
Top