hi
i have this code that copys and past stuff from another workbook and paste what i want from that work book to another work book in row d and e

what i need is to add the same words to rows a b and c while its copying over my info from other sheet
here is the code where it copies and paste the info over
Sub Gross_NAV()
Dim i As Long, LR As Long

    Dim AR As Long
    Dim dAveragePrep As Double
    Dim rng As Range
    Dim ang As Long
    Application.ScreenUpdating = False
On Error Resume Next
     Set ms = Workbooks("Book4.xlsx").Sheets("NOK IA1")
    With Worksheets("Allocation")

        LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
          For i = 1 To LR
             If IsDate(.Cells(i, 1)) Then
                 .Cells(i, 1).Copy
                MyDate = ms.Range("D" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial(xlPasteValues)
                MyDate.NumberFormat = "dd/mm/yyyy"
            End If
                If UCase$(.Cells(i, AG).Value) = "Gross NAV" And UCase$(.Cells(i, C).Value) = "NOK/IA1" Then
                                              
                .Cells(i, "AG").Offset(1).Resize(1).Copy
                
                MyData = Format(ms.Range("E" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial(Transpose:=True), Percent)
                    
     

               
              End If
          Next i
          End With
          

Application.CutCopyMode = 0

Application.ScreenUpdating = True

End Sub
is it possible to add text to the other rows while this is looping through and adding to sheet

if so can anyone help