I am pretty much a beginner with using Excel for anything other than simple sums, but I now have a budget spreadsheet to work on. I need a macro that will update a simple sum formula eg =SUM(B2:O2) to include the next adjacent column, eg =SUM(B2
2). I have recorded a macro that does that, and extends the formula change to the rest of the column, but I need to do this every month, to include the next column.
The spreadsheet is roughly like this:
Jan Feb March April May June Total To Date Projected Total
Salary1
Salary2
Salary3
Every month I have to update the Total to Date column to include the past month. At the moment all my macro does is extend the formula to a specific column (March) and that's it, rendering it useless for next month. Is my only option to record a new macro every month, or is there VB language to indicate the next adjacent column, rather than a specific column?
Apologies if this is a very simplistic question - I just feel sure there's a way of doing this that I just don't know about yet!
Thanks for any advice.
2). I have recorded a macro that does that, and extends the formula change to the rest of the column, but I need to do this every month, to include the next column.The spreadsheet is roughly like this:
Jan Feb March April May June Total To Date Projected Total
Salary1
Salary2
Salary3
Every month I have to update the Total to Date column to include the past month. At the moment all my macro does is extend the formula to a specific column (March) and that's it, rendering it useless for next month. Is my only option to record a new macro every month, or is there VB language to indicate the next adjacent column, rather than a specific column?
Apologies if this is a very simplistic question - I just feel sure there's a way of doing this that I just don't know about yet!
Thanks for any advice.