Adding Rows to different areas on a worksheet

I'm not to knowledgeable on the use of VBA coding yet and usually get my help from searching online forums like this to push myself to an eventual solution, but I'm having no luck on this one.

My issue is that I need to have a macro to add rows to a specific area on a worksheet that looks like this (There are multiple "Scopes"):
Scoping.PNG

I currently have a macro to add and deleted rows from Scope Group 1, which are assigned to the named buttons

Add

Please Login or Register  to view this content.

Delete

Please Login or Register  to view this content.

But I'm having an issue of doing a similar thing to Scope Group 2, 3, 4 etc., as when a row is added to Scope Group 1, the starting selected row will have moved either up or down.

I'm hoping to get help coming up with a dynamic function so that when a button on Scope Group 2 will add/delete a row in 2 and so on for Group 3, 4 etc.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

Use the row location of each button-shape to add\delete a row below the button.

You could assign these same macros to each Scope Group of buttons as long as each button has a unique name.

Please Login or Register  to view this content.

Thanks so much! The code works as it should, allowing me to add lines dependent on where the buttons are, but I'm having an issue now with the fill command I had, as I get the line added above line 1 in the particular Scope Group, but it does not copy the formatting of the line below it
Scope Grouping.PNG

This is the code that I use now as well

Please Login or Register  to view this content.

I don't know what you want. Do you want A6 to fill with 0? Do you want to renumber A6:A15 from 1 to 10? Are you asking about borders?

That made perfect sense. You're plenty word savvy. There are only about eight words (plus their variations) that have a double-v, and you used one one them. That makes you word savvy. But I digress...

Please Login or Register  to view this content.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.