Copying a formula in a column with different spreadsheets references.

[timgabel]

How do I copy formulas in a column containing a reference to a spreadsheet and a cell and have the reference to the spreadsheet change from spreadsheet 1 to 2 and 3 consecutively just like a relative cell number?

Example

Page1 E1+D2
Page 2 E+D2

How do I copy this data down a column and have the Page 1 change to Page 2, Page 3, etc. automatically?

 

[vogel997]

Enter the first formula, then drag or copy it down.

=INDIRECT("Page"&ROW(A1)&"!E1")+INDIRECT("Page"&ROW(A1)&"!D2")

=INDIRECT("Page"&ROW(A2)&"!E1")+INDIRECT("Page"&ROW(A2)&"!D2")

=INDIRECT("Page"&ROW(A3)&"!E1")+INDIRECT("Page"&ROW(A3)&"!D2")

=INDIRECT("Page"&ROW(A4)&"!E1")+INDIRECT("Page"&ROW(A4)&"!D2")

<colgroup><col></colgroup><tbody>
</tbody>

 

[timgabel]

Enter the first formula, then drag or copy it down.

=INDIRECT("Page"&ROW(A1)&"!E1")+INDIRECT("Page"&ROW(A1)&"!D2")

=INDIRECT("Page"&ROW(A2)&"!E1")+INDIRECT("Page"&ROW(A2)&"!D2")

=INDIRECT("Page"&ROW(A3)&"!E1")+INDIRECT("Page"&ROW(A3)&"!D2")

=INDIRECT("Page"&ROW(A4)&"!E1")+INDIRECT("Page"&ROW(A4)&"!D2")

<tbody>
</tbody>

I will give this a try and let you know if I have any issues or questions.

Thank you so much!

Tim