If the rows are inserted the Range also expanded automatically

Hi Geni
for progress reporting I structured my excel sheet as follows

The header is

Column Q is today's quantity and Column R is Previous Qty and Cloumn S is Cumulative Qty

In my Cell range Q10:Q60 is today's Qty

In my Cell range R10:R60 is Prev. Qty

For my updating the progress I have recorded a macro for this it is working well.

But if I inserted some rows, it is not working for this I need a Code

Please find attached