Hi,

In ( ) are the ref cells in sheet2 that I've entered the formula manually
sheet 1
A B C
1 (m125) (m126) (m127)
2 (n125) (n126) (m128)
3 (o125) (n127) (m129)

I want to avoid entering all the formulas manually.

when I drag and fill the formula down ='sheet2'!m125 I get

1 m125
2 m126
3 m127

when I drag and fill the formula across ='sheet2'!m125 I get

1 m125 o125

what am I doing wrong?