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.