Copying Rows of Formulas

  • Thread starter Thread starter John13
  • Start date Start date
J

John13

How can I copy Row 1 down without offsetting the referenced cells? I
copied it to Row 5 and it changed the reference to A5, B5, etc.

A B
C D
=Sheet2!A1 =Sheet2!B1 =Sheet2!C1 =Sheet2!D1 (Row 1)
=Sheet3!A2 =Sheet3!B2 =Sheet3!C2 =Sheet3!D2 (Row 2)

=Sheet2!A4 =Sheet2!B4 =Sheet2!C4 =Sheet2!D4 (Row 4)
=Sheet2!A5 =Sheet2!B5 =Sheet2!C5 =Sheet2!D5 (Row 5)

Also, can I make the cell formula Sheet reference number a variable?

Like: =Sheet(J1)!A1 instead of =Sheet3!A1 so I can control the sheet
number it looks at by changing the value of J1?

Thank you for your continuing Excel education, your service is
appreciated more than you will ever know.

John
 
Try this for the 2nd part of your question:

=INDIRECT("Sheet"&J1&"!A1")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


You have to add a $ before the column or row
$A$1
 
Try this for the 2nd part of your question:

=INDIRECT("Sheet"&J1&"!A1")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


You have to add a $ before the column or row











- Show quoted text -
Click to expand...

Thank you both very much, again I appreciate you taking time to teach!

John
 
Back
Top