Arlochorim
New Member
- Joined
- Oct 24, 2024
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
So I have a budget spreadsheet that is a list of values in different sections, a total at the bottom that sums each value in the section, and a overall total that sums all the section totals.
If possible I want to create a macro that allows me to press a button and insert a new row into a section, then update both the section total and overall total fields to include any values within that new row.
Don't mind making additional columns to the left to place the buttons and having a button for each section e.g. one button per section that creates a new row in a particular section, update the formula to include the new cell references within the total of that section, and updating the formula to include the new cell references of the overall total below,
It'd be a bonus if there was also a seperate button to delete a row to do the same thing in reverse, or even a button to create/delete a whole new section below the existing sections, but I'm not sure if you can dynamically identify what section boundries/locations like that.
Any help would be appreciated
If possible I want to create a macro that allows me to press a button and insert a new row into a section, then update both the section total and overall total fields to include any values within that new row.
Don't mind making additional columns to the left to place the buttons and having a button for each section e.g. one button per section that creates a new row in a particular section, update the formula to include the new cell references within the total of that section, and updating the formula to include the new cell references of the overall total below,
It'd be a bonus if there was also a seperate button to delete a row to do the same thing in reverse, or even a button to create/delete a whole new section below the existing sections, but I'm not sure if you can dynamically identify what section boundries/locations like that.
Any help would be appreciated