the intent is to have a sheet with pre-populated data (In this case the sheet called "Data" that I would like to use as a template to insert within certain rows on any given active working sheet.
The attached has two macros.
1- Insert Section: Copies and inserts range from the same sheet
2- Insert Pre-Build: Meant to copy a range from the "Data" sheet and paste back on the active sheet, which in this case is sheet 1. Just remember sheet 1 could be renamed to anything else, so I can't reference the active sheet name in the macro.
I have tried to modify the "Insert Section" code to Insert a range from sheet "Data" into the active sheet, but I can't get it to work.
I want to be able from the active working sheet, to initiate the macro to copy a range on the "Data" sheet and paste it within the active working sheet at the nominated location.
I have attached a sample file, which will hopefully assist. When asked what row to insert the "Insert Section" or the "Insert Pre-build" Macro, select row 35.
Appreciate any assistance.
The attached has two macros.
1- Insert Section: Copies and inserts range from the same sheet
2- Insert Pre-Build: Meant to copy a range from the "Data" sheet and paste back on the active sheet, which in this case is sheet 1. Just remember sheet 1 could be renamed to anything else, so I can't reference the active sheet name in the macro.
I have tried to modify the "Insert Section" code to Insert a range from sheet "Data" into the active sheet, but I can't get it to work.
I want to be able from the active working sheet, to initiate the macro to copy a range on the "Data" sheet and paste it within the active working sheet at the nominated location.
I have attached a sample file, which will hopefully assist. When asked what row to insert the "Insert Section" or the "Insert Pre-build" Macro, select row 35.
Appreciate any assistance.