Advanced Paste Function

[greg s]

Is there a way to copy a cell on, say C16 on Sheet1, that
references a cell on another worksheet cell (cell A1 on
Sheet2) and paste in cell C33 on Sheet1 but have it
reference cell A2 on Sheet2? I need to do this multiple
times and will be pasting it in cells C16,C33,C50,C67...
but need to have subsequently reference Sheet2 cell
A1,A2,A3,A4... Please help!!
Thanks in advance,
Greg

 

[Frank Kabel]

Hi Greg
if i understood you correctly this is not possible

 

[JE McGimpsey]

one way:

C16: =INDEX(Sheet2!A:A,INT(ROW()/17)+1)

 

[Guest]

Is there a way that the OFFSET function can do this.. I
can't seem to get it to work??

 

[JE McGimpsey]

I gave you a way using INDEX(). OFFSET() is similar:

C16: =OFFSET(Sheet2!$A$1,INT(ROW()/17),0)

 

[Guest]

JE,
You are a life saver, it works perfectly!! Thanks for
your help!
Best regards,
Greg