Hi Kristin,
Not sure whether that means what I wrote is not understood.
I could create a workbook with what was tested.
My example shows the results in column A,
and column B shows the address in column A with it's formula.

The use of the fill handle is what makes it simple (see links previously supplied)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Kristin" wrote ...
Thanks not sure what I'm doing here so all info is appreciated!

"David McRitchie" wrote:
A13 A1: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A26 A2: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)