Enter data in template

See more:

MS-Excel

How to fetch data into an excel template from an excel data dump?
Data has to be transposed.
Sample code:

Sheets("Sheet1").Select
Sheets("Sheet1").Range("C2:D2").Select
Selection.Copy
    Sheets("Sheet2").Select
    Sheets("Sheet2").Range("B2").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
   Sheets("Sheet1").Select
   Sheets("Sheet1").Range("E2:F2").Select
   
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet2").Select
    Sheets("Sheet2").Range("C2").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
    Sheets("Sheet1").Select
    Sheets("Sheet1").Range("A2").Select
End Sub

But have to do it for multiple rows.