Help with macro shortcut!

[Bruce$]

No experience with coding or macros. Trying to see if there is a simple way to create a shortcut for a repetitive process in an excel budgeting spreadsheet. Essentially the spreadsheet tracks invoices and costs against established budgets (shows costs to date, budget balances, etc.).

Invoices are plugged in each month when they are received. For example, if I receive an invoice in May 2020 it is captured in the May 2020 column and in the row of the budgeted line item associated with it (e.g. Design Costs). One of the first rows in the spreadsheet is "Costs to-date" which totals invoices received to date. Every month I have to adjust the formula in this column to capture the next month. So now that we are in May 2020, which is column N on my spreadsheet, I have to adjust the range of my formula. So the formula changes from "=SUM(K12:M12)" to "=SUM(K12:N12)". This formula is dragged down and applied to each row to reflect the costs to date for each budget line item.

As you can see, the formula itself and change I make to it is very simple. The problem is I manage multiple projects, each with its own budget, invoices, and workbook. I'm wondering if there is a shortcut I could create that updates my formula to capture the cell in the very next column, thus extending the selected range. Each month when I update the spreadsheet with current invoices I could simple "press a button" and the formula updates. I tried recording a macro to create a keyboard shortcut, but the problem is it only updates the formula once. It doesn't continue selecting the next column, and the next column, etc. each time I hit the shortcut on my keyboard. Not sure it's something I can record. I must reiterate that I have no clue what I'm talking about in terms of macros and am not sure if this is even possible. I don't know how to adjust the coding in the macro to make it do what I need. I'm having difficulty coming up with the words to even search for what I need through google, so I came here just looking for a place to start. Any advice is appreciated!

[TMS]

See the yellow banner.

[dangelor]

Should be an easy thing... if the workbook was here to see. Can you post an example workbook as described in the yellow banner above?

[Bruce$]

See attached.

[dangelor]

This will overwrite the Sum functions in columns D and E, depending on the current month. Test on a copy of your data.

Please Login or Register  to view this content.

[TMS]

I'm confused. The formulae in column F and G look a bit, well, static.

The SUM formulae to which you refer are elsewhere but I don't understand the logic.

D6: =SUM(I6:K6)
E6: =SUM(L6:P6)

[Bruce$]

The columns changed when I adjusted the spreadsheet to get rid of confidential info. That's my mistake. Column D totals the costs to date which, as of the last update to this spreadsheet, would be January through March. Column E totals April through the remainder of the project, August 2020. Sorry for the confusion I didn't adjust my post to reflect the changes in headers, columns, etc. when I removed confidential info.