VBA code to paste values of specific cells onto next empty row on another sheet

[Katyjean1]

I can't figure out how to edit this code to paste values. I've search so many forums. Can anyone help?

Sub SUBMIT()
'
' SUBMIT Macro
'


'
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim DestRow As Long
    Set ws1 = Sheets("Entry Form")
    Set ws2 = Sheets("Reconcile")
    DestRow = ws2.Cells(Rows.Count, "A").End(xlUp).Row + 1
    ws1.Range("O8").Copy ws2.Range("A" & DestRow)
    ws1.Range("O6").Copy ws2.Range("B" & DestRow)
    ws1.Range("H6").Copy ws2.Range("C" & DestRow)
    ws1.Range("O10").Copy ws2.Range("D" & DestRow)
    
 End Sub

 

[Fluff]

Try

ws2.Range("A" & DestRow).value =ws1.Range("O8").Value

 

[Katyjean1]

Worked! Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback