Copying Rows of Formulas

[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

 

[AD]

You have to add a $ before the column or row
$A$1

 

[RagDyeR]

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

 

[John13]

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 -

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

John

 

[Ragdyer]

And we appreciate the feed-back.