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
DeletePlease 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.Please Login or Register to view this content.
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.
Bookmarks