Apply Macro for 1 row to all rows (it adds values from one set of columns to other set)

[lizmarie]

Hi All:

I have a macro that adds the values in three columns to three other corresponding columns in the same sheet. The macro then zeros out the columns from the first set (after the adding takes place) and also zeros out the date column associated with those values. This is the code (FYI: I am new to macros):

Please Login or Register  to view this content.

I have a TWO questions:

First: Instead of zeroing out the date, I actually want the date to change to Date + 1 month -- how can I do that? (the K and X columns are the Date columns)

Second, and most important: I want to apply this macro to ALL rows, not just the one -- how can I do that?

For context (to the extent it helps), I have one spreadsheet that is tracking "life of file" spend (for litigation) as well as a quarterly spend that includes Hours, Fees and Costs (these are the three columns). At the end of each quarter, I want to be able to use the macro to add the quarterly spend (hours, fees, costs) to the associated "life of file" spend columns. I then want the quarterly spend column to zero out and have the date updated to the next month (first month of new quarter).

Thanks in advance for any help here!!

[sktneer]

Please try the below code.......

Please Login or Register  to view this content.

Here this code will run for row no.2 to the last row with data in column K. You can change these red colored values as per your need.

I hope this helps.

[lizmarie]

Sktneer -- Thank you so much for sending this response, I really appreciate it. One question though, it is telling me that I have a variable not defined, it is the i in "For i = 2 to lr" -- any thoughts? Thank you again for this!

[sktneer]

You can declare i variable just below the line Dim lr As integer. like

Dim i As Integer

And lr is already declared.

[lizmarie]

Thank you so much Sktneer -- that worked perfectly!! Much appreciated.

[sktneer]

You're welcome. Glad to help you.