Copy Formula to additional columns
 

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

Copy Formula to additional columns
 

='Incidents - Accidents'!C19
Replace the above with this, copy down as required:
=OFFSET('Incidents - Accidents'!$C$19,,ROWS($1:1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lise" wrote:
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

Copy Formula to additional columns
 

Thanks for this Max - Excellent.

Kind Regards

Lise (Australia)

"Max" wrote:

='Incidents - Accidents'!C19
Replace the above with this, copy down as required:
=OFFSET('Incidents - Accidents'!$C$19,,ROWS($1:1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lise" wrote:
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

Copy Formula to additional columns
 

Welcome, Lisa. Thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lise" wrote in message
...
Thanks for this Max - Excellent.