if you have your row data in sheet2 starting in cell A1,
and then want to link to it in another sheet and just copy
the equation DOWN, you can use the following (assuming
you're starting in cell A1 on the other sheet):
=OFFSET(Sheet2!$A$1,0,ROW()-1,,)
if you start in a row 2, make that row()-2 (i.e. you
always have to subtract out the row where you start the
equation). You can just fill that down and it will link
to the row as if you were filling across.
Does that make sense? Was that even what you were looking
for? Hope it helps,
Karen
