I can't download your attachment.

If you set the data up in an Excel Table (put the cursor in the table then click Insert | Table), then Excel will automatically copy formulae into newly-inserted rows and if you add data to the bottom of the table.

Hope this helps.

Pete