Copy and Paste sheet into a range of sheets from list

I have 3 macros where one macro calls two others.
I have pasted the code below but i am struggling with the CopyAndPasteSheet macro.

I have a button which runs the macro CreateDevicelList.
CreateDeviceList in turn calls CreateSheetsFomList.
CreateSheetsFromList creates new worksheets and names the new sheets based on the list on the List Sheet starting at C1.
Finally the data on the sheet Master is to be copied and pasted into each of the new sheets created in CreateSheetsFromList. Then delete rows 1 to 5.

Please Login or Register  to view this content.

So, wouldn't it be better to simply create copies of the MasterSheet as a template and rename each of these new sheets to your List names, then delete rows1:5?

I understand, but that doesn't answer the question. Sometimes breaking out short routines into even shorter ones is the wrong thing to do.

Right now you have 3 macro to do one thing... create copies of the Master with new names without rows1:5. That really is a simple one-macro thing.

Please Login or Register  to view this content.

Can you adapt this type of approach into your need to use it on multiple buttons for various things?

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.