1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Sub Recup_Valeurs()
Dim f1 As Worksheet, f2 As Worksheet
Dim DerLig_f2 As Long
Application.ScreenUpdating = False
Set f1 = Sheets("Sheet1")
Set f2 = Sheets("Evolutions_journalieres")
DerLig_f2 = f2.Range("A" & Rows.Count).End(xlUp).Row
If f1.Range("B1") <> f2.Cells(DerLig_f2, "A") Then
f2.Cells(DerLig_f2 + 1, "A") = f1.Range("B1")
f2.Cells(DerLig_f2 + 1, "B") = f1.Range("F20")
f2.Cells(DerLig_f2 + 1, "C") = f1.Range("M20")
f2.Cells(DerLig_f2 + 1, "D") = f1.Range("T20")
End If
f2.Select
Set f1 = Nothing
Set f2 = Nothing
End Sub |
Partager