I am new to VBA and I am trying to write a macro to copy data from Product File to FileMaster. My problem is I want data to be copied to next empty row in FileMaster.
For example FileMaster is filled with previous data up to cell C50 and I want my data copied from cell C51 but is struggling with this.
My code is as below but it kept copying data from cell C2
Dim LastRow As String
FileMaster.Activate
LastRow = ActiveSheet.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Workbooks("Product File.xlsx").Worksheets("data").Range("A2:N" & Range("A" & Rows.Count).End(xlUp).Row).Copy Workbooks("FileMaster.xlsx").Worksheets("new_template").Range("C2:N" & LastRow)
Application.CutCopyMode = False
Much appreciate any help with this. Thank you so much.
New contributor
Quynh Trang Pham Do is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.