Hi,
I am very new to VBA so bear with me! I have done quite a bit of research into this to no avail (I have no macros I can show). Using Excel 2010, I am trying to write VBA code to insert a set of 24 rows above a separator bar in an Excel sheet (to be treated as a form), and copy and paste a range at the click of a button (by the user) underneath the last range in the form.
The idea is to provide the user a button they can click if they want to insert an additional "table" for them to complete underneath the existing ones.
The reason I need a macro for this is because the sheet will be protected.
The reason for the separator bar (always to be on the bottom) is for formal/professional appearances.
Attached is a workbook with current and desired situations.
Cheers for your help!![]()
Bookmarks