1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| Sub ACTUALISATION_DONNEES_TDB()
Dim i As Integer, j As Integer, Derlig As Integer
Dim Ligvid As Integer
Dim Tampon1 As Integer
Dim Tampon2 As Integer
Dim Tampon3 As Integer
Dim Tampon4 As Integer
Application.ScreenUpdating = False
'Lance la sub EFFACER pour purger le tableau avant compilation
EFFACER
For j = 4 To 5
Sheets(j).Select
Derlig = Sheets(j).Range("A" & Rows.Count).End(xlUp).Row
For i = Derlig To 2 Step -1
Sheets(j).Select
If UCase(Range("G" & i)) = "1" Then
'mémorisation de la plage à transfèrer
Tampon1 = Sheets(j).Range("A" & i & ":A" & i)
Tampon2 = Sheets(j).Range("C" & i & ":F" & i)
Tampon3 = Sheets(j).Range("H" & i & ":J" & i)
Tampon4 = Sheets(j).Range("L" & i & ":L" & i)
'Tampon = Range(Cells(Lig, "A"), Cells(Lig, "L"))
With Sheets("Tableau de bord")
'1° ligne vide
Ligvid = .Columns("A").Find("", .Range("A1")).Row
'écriture de la plage
With .Range(.Cells(Ligvid, "A"))
.Value = Tampon1
'écriture de la plage
With .Range(.Cells(Ligvid, "B"), .Cells(Ligvid, "E"))
.Value = Tampon2
'écriture de la plage
With .Range(.Cells(Ligvid, "F"), .Cells(Ligvid, "H"))
.Value = Tampon3
'écriture de la plage
With .Range(.Cells(Ligvid, "I"))
.Value = Tampon4
End With
End With
End With
End With
End With
End If
Next
Next
Sheets("Tableau de bord").Activate
End Sub |
Partager