Moving or Copying Data from one Worksheet to another Worksheet using VBA in Excel - Code Included

Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-started
Transfering data from one worksheet to another worksheet is a very commonly used VBA macro. In this video we used a comand button to copy data from one sheet to another worksheet.

Code:
=============
Private Sub CommandButton1_Click()

erw = Sheet2.Cells(1, 1).CurrentRegion.Rows.Count + 1

If Len(Range("D12")) __ 0 Then
Sheet2.Cells(erw, 1) = Range("D12")
Sheet2.Cells(erw, 2) = Range("D13")
Sheet2.Cells(erw, 3) = Range("D14")

Range("D12") = ""
Range("D13") = ""
Range("D14") = ""

Else
MsgBox "You must enter a name"
End If

End Sub

Видео Moving or Copying Data from one Worksheet to another Worksheet using VBA in Excel - Code Included канала EverydayVBA