Copy Formula to additional columns

L

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 :)
 
M

Max

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