with data in column A, this formula in cell C1 (and copied down) will return
the contents of A1 in C1:C10, A2 in C11:C20, etc......adapt as needed.

=OFFSET($A$1,INT((ROWS(C$1:C1)-1)/10),0)


"jostlund" wrote:

Can someone help me with what I think will be an offset formula.
My spreadsheet is used to prepare an import file for Accpac. Every 10 rows,
colum D is linked to a customer number in another worksheet. The source
worksheet has data in continuous rows. The import file has data for the same
customer in 10 rows so column D, every 10 rows, the link should only increase
by 1, not 10. Thanks in advance!