Add or remove a selection of rows with a button

[suxrule]

Hi,

My ask seems very complicated as it look like it will need VBA knowledge of which I have none, so please just tell me it's too complicated for someone like me and I'll leave it.

I want to add and delete a selection of rows with a + or - button of some sorts but it will always need to be inserted above a certain cell as that cell will have a total in it.

I've attached a screen shot of the rows I'd like to duplicate or remove, will any formulas automatically adjust if I ever get it working?

Here's a copy of the actual spreadsheet (can't get the mini sheet add-on working) - Actual Spreadsheet

Any help much appreciated.

 

[suxrule]

Ok I've just gone with the "Are you sure?" method because as you say it's not the end of the world if someone accidentally deletes the last set of rows.

Can I ask one very last question and I'll leave you alone?

So when I add a set of rows using the "Add Colleague" button my formula in the bottom "Totals" cells doesn't change to accommodate the added cels. Is there a way of making this happen?

LINK TO FULL SPREADSHEET - (no password)

 

[EXCEL MAX]

You have added one row more between box "Total Hours This Week" and last row set.
It makes confusion to calculate. The easiest way to resolve this is to delete this row and keep only one.
Also you have added few rows on the top. Take care about that.

 

[suxrule]

OK perfect, I think I'm where I need to be with this now...on to my next problem...but I won't bother you with that lol thanks so much for your help, literally couldn't of done it without you ?

 

[EXCEL MAX]

I'm glad that we successfully found solution for this few steps. Cheers...