Copy Formula to additional columns

  • Thread starter Thread starter Lise
  • Start date Start date
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 :-)
 
='Incidents - Accidents'!C19
Replace the above with this, copy down as required:
=OFFSET('Incidents - Accidents'!$C$19,,ROWS($1:1)-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
Copy Problem with 2007 Conditional Format 4
Insert Formula and Copy to other cells 1
Autofill column values in formulas 4
Subtracting minutes in an +IF formula 13
Excel Help to copy information from one row at a time to another sheet 1
#VALUE 2
Add row dynamically 15

Back
Top