Excel - Populate cells based on row selection

Asked By Dave on 10-Apr-08 02:46 AM
I'm having trouble figuring out how to populate cells based on
selecting a row. I basically have 5 columns with descriptive headers
with different values in each row. I would like to select a row and
have the 5 selected cells populate 5 main cells in another part of the
spreadsheet. Thus, of course those cell values will change everytime a
user selects a different row.

It's easy to use = and point to a particular cell (eg A3) but what if
that column letter changes all the time but the row number remains the


Castell replied on 08-Apr-08 03:17 PM
Use the =. Excel adjusts the formulas if you insert new rows or columns.