Thank you stevekirk and Leith Ross.

Before I attempt what appears to be the more complicated method (stevekirk), I have tried Leith's method, but nothing seems to happen at all.

Perhaps I should clarify further that the first 7 rows are header rows, row 8 contains formulas (where applicable) and columns, A, B, K, L and AF to DL contain columns with pre-set formulas which I want copied down whenever a user enters data into a new row (i.e. in any one of the other columns).

Once again, thanks for your help.