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