Hello,
I am new to programming, but have been tasked with revamping a budget form that will be used across a wide variety of projects that can vary in size. I initally added plenty of additional rows to account for the larger projects and then kept them hidden for the smaller projects, but I am not sure that will be the best option going forward.
I have started looking at the possibility of adding buttons to each section that would effectively allow the budget to expand to accomodate each project, but I am struggling with working out the code. I thought I had it figured out, but then realized that if I use the buttons at the top, then the later buttons do not insert rows in the correct location.
For the "Income" section I would like to copy the row below the button, and then just insert it at the top of the section so the formatting and formulas carry over. Same with the "Expenses" area, expect I need to copy/insert the entire section (rows 25-33) so all the line items are duplicated as well.
Any guidance?
Bookmarks