Export worksheet to another workbook without overwriting existing entries (search?)

[Photomommie]

I am attempting to make a thing that will take the data from the current workbook (OVC Process v1.0.3.xlsm), Sheet named "Data" and after clicking button, upload that data into another workbook "OVC Metrics.xlsx", Sheet named "Data" on a Sharepoint site. I can do the copy/past function, but I need help with the overwrite function.
Here's what I got:

Sub Update_All()

Dim wkb1 As Workbook
Dim sht1 As Worksheet
Dim wkb2 As Workbook
Dim sht2 As Worksheet
LoadFilePath = "..........blah blah....OVC_Metrics.xlsx"

Application.ScreenUpdating = False
Application.AskToUpdateLinks = False


Set wkb1 = ThisWorkbook
Set wkb2 = Workbooks.Open(LoadFilePath)
Set sht1 = wkb1.Sheets("Data")
Set sht2 = wkb2.Sheets("Data")

' Copy Rows
sht1.Range("A2:V1500").Copy

' Find Last Row
lastrow = sht2.Cells(Rows.Count, "A").End(xlUp).Row

' Paste Rows
sht2.Range("A" & lastrow + 1).PasteSpecial xlPasteAll

' Close Database
wkb2.Close SaveChanges, Filename:=True
MsgBox "Thanks for Uploading your Data! You're the best!"

Application.ScreenUpdating = True

End Sub

If anyone could help me with this I'd be greatful.

[JLGWhiz]

If you are overwriting some of your data, then your last row variable based on column A data probably needs to be based on the actual column with the most data. So replace this

lastrow = sht2.Cells(Rows.Count, "A").End(xlUp).Row

with this

lastrow = sht2.Cells.Find("*", , xlValues, xlPart, xlByRows, xlPrevious).Row

That will give you the last row with data in any column.

[Photomommie]

Excellent! This works locally. Now I need to figure out how to upload to sharepoint site. When I update the LoadFilePath to the sharepoint address, it gives me a "subscript out of range" error. Any tips on this?

[JLGWhiz]

click the debug button to see which object it is that the compiler cannot find. Remember when putting it on the sharepoint drive that some of your filenames or sheet names might change, so the code has to be modified to adapt those changes.

[Photomommie]

Got it! This worked after I updated links on the wkb2

[JLGWhiz]

Got it! This worked after I updated links on the wkb2

thanks for the feedback, Don't forget to mark the thread as solved.
Regards, JLG