Create Macro to Add Rows when the # of rows vary each month

The easiest way is probably to calculate the last row, then put a sum formula in the columns you want totalled... Assuming column A always has data, something like this:

Please Login or Register  to view this content.

Hi debi,

What I provided is not so much used to make a macro.... it IS a macro I realize you may want to integrate it into other code, if so maybe provide what you have and I can help.

This line:

Please Login or Register  to view this content.

uses the variable "lr" (which is the last row with data in it in column A, to build the forumla for the total of column H, summing the second row to the last one.
if you want to change that column, just change the letter H (3 places) to another column letter, or if you simply want to add other totals, copy the line, and paste it either above or below, and change the H in the copy to match the other column's letter.
Hope that helps a little, but feel free to come back with more questions.

Hi,

I have attached one of my sample spreadsheets and then my formatting macro as I wasn't sure where to insert it to the other tasks within the macro.

Thanks for the help.

Hi debi,

I noticed you have a recorded macro, which is a great tool, but often can use some cleanup. I took the liberty of making some changes, in particular removing tasks where a range or cell is selected, and then the code uses "selection." ....
In those cases it is almost always better to work with the range itself. Have a look and see if this produces the desired result?:

Please Login or Register  to view this content.

Glad to help

This thread is full of suggestions: https://www.excelforum.com/excel-pro...materials.html

By using the recorder you will get a lot of help, and as you practice more, you will see that a lot can just be cleaned up after you have the basic structure.
Google was my best friend for learning... I simply googled what I was trying to do, and read some possible approaches, I wish I'd found this forum earlier on, but it has helped me a lot.

Please remember to mark the thread as solved if your question was resolved? Thanks in advance.