vb help - adding data to next available line

[steve2115]

I am in need of some help with a piece of vb code to add data to the next available blank row on an existing excel sheet named "MB51"

I need to browse for and then import data from an excel file (data is in columns A:N and then import all the data from that file into the first blank row on sheet MB51 , columns C:L

Here is code I currently have.

Sub Button1_Click()
Dim OpenFileName As String
 Dim wb As Workbook
 'Select and Open workbook
 OpenFileName = Application.GetOpenFilename("MB51,*.xlsx")
 If OpenFileName = "False" Then Exit Sub
 Set wb = Workbooks.Open(OpenFileName)
 'Get data EXAMPLE
 ThisWorkbook.Sheets("MB51").Range("C" & Rows.Count).End(xlUp).Row 1 = wb.Sheets(1).Range("A:N").Value

 MsgBox ("Import Complete")
wb.Close
    
    
End Sub