voici mon code qui n'est pas beau (je sais mais ce sont mes premiers pas ds le vba)
Sub Suivi_PLF()
'supprime les rafraîchissements d'écran
Application.ScreenUpdating = False
Sheets("Formation").Select
If Range("J3").Value = "" Then
MsgBox "Vous avez oublié de saisir une propostion de date"
End If
' Ligne 1
Sheets("Formation").Select
If Range("J3") <> "" Then
'nom personnel
Range("D1
3").Select
Selection.Copy
Sheets("Suivi PLF").Select
Range("C30001").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
'Formation
Sheets("Formation").Select
Range("D4,F4").Select
Range("F4").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("F30001").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Autres points
Sheets("Formation").Select
Range("G4:K4").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("J30001").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
end sub
' Ligne 2
Sheets("Formation").Select
If Range("J5") <> "" Then
'nom personnel
Range("D1
3").Select
Selection.Copy
Sheets("Suivi PLF").Select
Range("C30002").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
'Formation
Sheets("Formation").Select
Range("D5,F5").Select
Range("F5").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("F30002").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Autres points
Sheets("Formation").Select
Range("G5:K5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("J30002").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
' Ligne 3
Sheets("Formation").Select
If Range("J6") <> "" Then
'nom personnel
Range("D1
3").Select
Selection.Copy
Sheets("Suivi PLF").Select
Range("C30003").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
'Formation
Sheets("Formation").Select
Range("D6,F6").Select
Range("F5").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("F30003").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Autres points
Sheets("Formation").Select
Range("G6:K6").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Suivi PLF").Select
Range("J30003").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
'Faire les autres lignes
'tri
Sheets("Suivi PLF").Select
Range("C2:AA30100").Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("C5").Select
'Efface
Sheets("Formation").Select
Range("D1,F4:K44").Select
Range("F4").Activate
Application.CutCopyMode = False
Selection.ClearContents
Range("D1").Select
End Sub