Excel question? Regarding cell formula

[Guest]

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

 

[David McRitchie]

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

 

[Otto Moehrbach]

"=A172" in A13 without the quotes.
Is this what you want? HTH Otto

 

[Guest]

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




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?

 

[Guest]

Thanks............................and to continue this pattern without typing
it each cell??????

 

[David McRitchie]

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)



continue......................to do the same....is that possible so that I don't have to type the infomation into each cell?

 

[Guest]

Thanks not sure what I'm doing here so all info is appreciated!

 

[David McRitchie]

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)