Good morning,

I have a range of cells in a sheet that I am wanting to insert data in to and then populate with data. (there is other information in the rows so I dont want insert rows.

I have the following for the insert, but the populate is very manual

 Range("K6:L6").Select
    Selection.Insert Shift:=xlDown
Currently I have the populate as a cell reference, but this list may change regularly.

Range("K3").Select
    ActiveCell.FormulaR1C1 = "Script"
    Range("L3").Select
    ActiveCell.FormulaR1C1 = "Target"
    Range("K4").Select
    ActiveCell.FormulaR1C1 = "DL1  "
    Range("L4").Select
    ActiveCell.FormulaR1C1 = "0.32"
    Range("K5").Select
    ActiveCell.FormulaR1C1 = "DV9  "
    Range("L5").Select
    ActiveCell.FormulaR1C1 = "0.32"
    Range("K6").Select
    ActiveCell.FormulaR1C1 = "ED2  "
    Range("L6").Select
    ActiveCell.FormulaR1C1 = "0.77"
    Range("K7").Select
    ActiveCell.FormulaR1C1 = "DX8  "
    Range("L7").Select
    ActiveCell.FormulaR1C1 = "0.77"
Is there a way that I can have the cells insert and populate the next cells down rather than including a cell reference? The above is just a sample. I have a heap that I need to insert (and change) on a regular basis.