Hello Roy Lee,
Here is the updated macro code...
Private Sub CommandButton1_Click()
UserForm2.Show
End Sub
Private Sub CommandButton2_Click()
Dim DstRng As Range
Dim DstWks As Worksheet
Dim SrcRng As Range
Dim SrcWks As Worksheet
Set DstWks = Worksheets("Sales Data")
Set DstRng = DstWks.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Resize(1, 3)
Set SrcWks = Worksheets("Purchase Order")
Set SrcRng = SrcWks.Range("B5:D9")
For r = 1 To 5
DstRng.Cells(r, 3).Value = SrcRng.Cells(r, 1).Value
DstRng.Cells(r, 2).Value = SrcRng.Cells(r, 2).Value
DstRng.Cells(r, 1).Value = SrcRng.Cells(r, 3).Value
Next r
End Sub
Bookmarks