Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column
Sounds like you are entering data in a list. I would just use Data|Form to
enter a new row of data. All cells above the new row that have formulas
will automatically be copied down. To copy a cell from the row above that
has a constant in it, press Ctrl+; (Ctrl+ semicolon) while in that field.
--
Regards,
Bill Renaud
|