Private Sub Workbook_AfterSave(ByVal Success As Boolean)
Dim Wb As Workbook
Dim Wi As Worksheet
Dim Wt As Worksheet
Set Wi = ThisWorkbook.Worksheets("Feuil1")
Set Wb = Workbooks.Open(ThisWorkbook.Path & "\Test2.xlsm")
Set Wt = Wb.Worksheets("Feuil1")
For i = 1 To Wi.UsedRange.Rows.Count
For Each C In Array("B", "H", "N")
If Wi.Cells(i, C) <> vbNullString Then Wt.Cells(i, C) = Wi.Cells(i, C)
Next
Next
Wb.Close True
End Sub