How can I create a button to insert a new row and update related formulas?

Arlochorim

New Member
Joined
Oct 24, 2024
Messages
1
Office Version
  1. 2016
Platform
  1. 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
 

Attachments

  • Screenshot 2024-10-25 072612.png
    Screenshot 2024-10-25 072612.png
    87.5 KB · Views: 15

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,853
Messages
6,175,013
Members
452,600
Latest member
nicoCrous75

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top