Copy Formula to additional columns

[Lise]

Hi all - sorry if silly question but....

I have formula
='Incidents - Accidents'!C19
I want to copy down a column so next is D19 - E19 etc but can only get the
result to change the row number not the cell number - Can anyone suggest a
solution.

Many thanks

 

[Max]

='Incidents - Accidents'!C19
Replace the above with this, copy down as required:
=OFFSET('Incidents - Accidents'!$C$19,,ROWS($1:1)-1)

 

[Lise]

Thanks for this Max - Excellent.

Kind Regards

Lise (Australia)

 

[Max]

Welcome, Lisa. Thanks for feeding back.