Macro to insert rows copy only formulas from above row and retain sum of Columns on bottom

Hi

Just joined and complete newbie on macros. I have a data sheet which has undertermined rows adn needs a sum function at the bottom.

I am looking for a way to auto copy the last row with formulas which update cell refs accordingly but no values and still retain the bottom sum row by moving it down.I have a range E to AD
(with a key shortcut, if cannot automatically do).

Hope ive explained clearly enough. The code I have found so far works but copys exactly the formula in cell E rather than incremeting the cell references and also does not include the other formulas in may range. The code is below, can this be adapted or am i on the wrong track?

Please Login or Register  to view this content.

Have tried making the range A:AD but this caused an error and also only copied the formula exactly and not incrementally.

Any help appreciated.

Moderators Note: Please follow forum rules and use code tags. Added for you this time, but please use them in the future…Thanks.