Vertically Copying Horizontal Cell Links

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to copy cell links in a row on one sheet to a
column on another. Paste special, transpose does not
work. ANy help?
 
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
 
Back
Top