Hi Kristin,
Please put your response BEFORE the quoted previous responses,
your newsreader is not distinguishing your replies from the previous response,
It all looks like quoted material. Best to describe what you want the first time.

You might get a better idea from these two pages
http://www.mvps.org/dmcritchie/excel/fillhand.htm Fill Handle
http://www.mvps.org/dmcritchie/excel/snakecols.htm Snake columns
http://www.mvps.org/dmcritchie/excel/offset.htm use of OFFSET

A13 A1: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A26 A2: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A39 A3: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A52 A4: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A65 A5: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A78 A6: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A91 A7: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A104 A8: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A117 A9: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A130 A10: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A143 A11: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A156 A12: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A169 A13: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)
A182 A14: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kristin" wrote in message ...


"David McRitchie" wrote:

Just like your current formula in cell ...
A12: =A129
you create a formula for cell ...
A13: =A172

"Kristin" wrote in message ...
If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a
formula that will pull A172 to cell A13?


Thanks, but how do I create a formula that will continue to pull information from a cell 43 rows down and
continue......................to do the same....is that possible so that I don't have to type the infomation into each cell?