How would I copy a formula down a column until the last row.
I have data being output to a workbook and the number of rows change each
time I run the report. In cell M2 I wish to enter the formula =sum(L2-K2)
and then copy this down to the end cell in column M, so M3 = =sum(L3-K3), M4
= =sum(L4-K4) and so on