Bonsoir,
j'ai chargé les 2 fichiers du post #1.
Je ne sais pas quoi en faire, il n'y a aucune macro
ni dans l'un ni dans l'autre
Dans "Dossier Recap", pas de filtre en cours .
Je pense que la macro est restée dans votre dossier de macro personnel ( \PERSONAL.XLSB'!Macro4 )
En effet, j'ai oublié de la changer de lieu. La voici mais elle ne marche pas
Sub Macro4()
'
' Macro4 Macro
'
'
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveSheet.Range("$A$4:$N$568").AutoFilter Field:=13, Criteria1:=Array("1" _
, "10", "11", "12", "2", "3", "4", "5", "8", "9"), Operator:=xlFilterValues
ActiveWindow.SmallScroll Down:=-33
ActiveCell.Offset(-19, -11).Range("A1:B1").Select
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Select
ActiveSheet.Paste
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(0, 7).Range("A1:B1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Offset(0, 3).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(0, -3).Range("A1:C1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Offset(0, -1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A1").Select
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(0, 3).Range("A1:B1").Select
Application.CutCopyMode = False
Selection.Copy
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(5, -7).Range("A1").Select
Application.CutCopyMode = False
ActiveCell.Range("A1:A196").Select
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveSheet.Paste
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(0, 3).Range("A1:A196").Select
ActiveCell.Offset(195, 3).Range("A1").Activate
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveSheet.Paste
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveWindow.SmallScroll Down:=-9
ActiveCell.Offset(-195, 6).Range("A1:A196").Select
ActiveCell.Offset(0, 6).Range("A1").Activate
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveWindow.SmallScroll Down:=-15
ActiveCell.Select
Windows("Réassort Bozel hiver 2019.xlsx").Activate
ActiveCell.Offset(-200, -5).Range("A1:C1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Recapitulatif.xlsx").Activate
ActiveCell.Range("A1:A30").Select
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(9, 0).Range("A1").Select
End Sub