Hello,
I currently have a macro that runs across 31 sheets to copy and paste data from each of them into one place. The number of rows that the macro takes is dependent on the information in the sheets and will most likely be different every time you use it. I am trying to get a summation of each row in the column to the right of the table. This is easily done by typing for instance '=sum(L3:P3) in cell O3 and then dragging the corner down to copy the formula to the bottom of the table, however, there may be hundreds to thousands of rows and, as I said before, it is never the same.
Any ideas on the macro I could use to accomplish this so I don't have to manually drag that formula every time?

Thank you in advance