try:
=INDEX(Sheet2!A:A,INT((ROWS(A$1:A1)-1)/10)+1)


"SNACK D" wrote:

I have two sheets, and am trying to link cells (copy the same vallue) from
the second sheet into the first. The problem is, the first sheet has 10
blank rows between each link I'm trying to paste in from the seccond sheet.
The second sheet does not have any blank rows between the data.

I'd like a formula that would take into account this offset as I copy the
link on first sheet down. I.E. once I link cell A1 from second sheet to cell
A1 in the first sheet, I want to copy cell A1 in first sheet to cell A11 in
first sheet, but want it to reference cell A2 in the second sheet.