Sub Transfert()
Dim source As Range, dest As Range, jour%
Set source = Sheets("JUPILER PRO LEAGUE").[G4:H12]
Set dest = Sheets("%").[I5:J13]
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
dest.Parent.Protect "toto", UserInterfaceOnly:=True
For jour = 1 To 34
dest(0, -1) = "JOURNEE " & jour 'titre
dest = source.Value 'copie les valeurs
Set source = source.Offset(11)
Set dest = dest.Offset(12)
Next
Application.Calculation = xlCalculationAutomatic
End Sub