[RESOLVED] [Excel] Copy data from specific cells to another workbook

[westconn1]

As a note, is it possible to use a network patch to open the closed source?

assuming this means PATH, then yes

so if the last row was Number 2 it needs to copy on row 3

try like

nextrow = wbkdes.Sheets("Récup Info").cells(wbkdes.Sheets("Récup Info").rows.count, 1).end(xlup).row + 1
wbkdes.Sheets("Récup Info").Cells(nextrow, 1) = wbksour.Sheets("Bon de Travaux").Cells(28, 16)
' rest of code to fill cells