title: Excel Macros to populate data from master sheet into multiple template sheets
body: <p>I have an excel sheet that has a sheet with the structure as below:</p>
  
  <p><a href="https://i.stack.imgur.com/0LtLK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0LtLK.png" alt="enter image description here"></a></p>
  
  <p>I want to create separate sheet for each 'Model name'. My code below does it correctly. </p>
  
  <pre><code>    Option Explicit
  Sub Splitdatatosheets()
  '
  ' Splitdatatosheets Macro
  '
  '
  Dim rng As Range
  Dim rng1 As Range
  Dim vrb As Boolean
  Dim sht As Worksheet
  Set rng = Sheets("Sheet1").Range("A4")
  Set rng1 = Sheets("Sheet1").Range("A4:BD4")
  vrb = False
  Do While rng &lt;&gt; ""
      For Each sht In Worksheets
             If sht.Name = Left(rng.Value, 31) Then
                  sht.Select
                  Range("A2").Select
             Do While Selection &lt;&gt; ""
                   ActiveCell.Offset(1, 0).Activate
             Loop 
              rng1.Copy ActiveCell 
              ActiveCell.Offset(1, 0).Activate 
              Set rng1 = rng1.Offset(1, 0) 
              Set rng = rng.Offset(1, 0) 
              vrb = True 
          End If
      Next sht 
      If vrb = False Then
      Sheets.Add After:=Sheets(Sheets.Count)
      ActiveSheet.Name = Left(rng.Value, 31)
      Sheets("Sheet1").Range("A3:BD3").Copy ActiveSheet.Range("A1")
      Range("A2").Select               
      Do While Selection &lt;&gt; ""               
          ActiveCell.Offset(1, 0).Activate                    
      Loop
      rng1.Copy ActiveCell
      Set rng1 = rng1.Offset(1, 0)    
      Set rng = rng.Offset(1, 0)    
      End If    
  vrb = False
  Loop
  End Sub
  </code></pre>
  
  <p>However, I want to create the sheets with a specific template. I want to populate the data in a template fashion. I want to populate the data in the below fashion:</p>
  
  <p><a href="https://i.stack.imgur.com/KKjCl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KKjCl.png" alt="enter image description here"></a></p>
  
  <p>I want to populate data in a template fashion. Any clue on how my code can be fixed?</p>