Add Formatted new rows on multiple tabs

[JoeCam]

I'm trying to create a way for users to click a button that will add new rows to a workbook.

For every sequence of 2 rows on Sheet 1, I have a corresponding sequence of 13 rows on Sheet 2. I need to make sure they remain in sync, so I'm looking for a way that each time I click a button 2 new rows are added to Sheet 1 & 13 new rows are added to Sheet 2 and they all get the appropriate formatting/formulas/etc.

I could easily create the template that should be copied in each place on a 3rd sheet in defined ranges so that they can be copied if that would make it easier.

 

[Logit]

If you created the template, then it would only be a matter of copy / paste with formatting etc.

Otherwise you would need to understand VBA coding to program the same.