Sub Infos()
'
' Infos Macro
'
'
ActiveCell.FormulaR1C1 = _
"=IF(ISERROR(INDEX(extract!R1C6:R1500C7,MATCH(SMALL(extract!R1C6:R1500C6,COLUMN()-2),extract!R1C6:R1500C6,0),2)),"""",INDEX(extract!R1C6:R1500C7,MATCH(SMALL(extract!R1C6:R1500C6,COLUMN()-2),extract!R1C6:R1500C6,0),2))"
Range("C1").Select
Selection.AutoFill Destination:=Range("C1:IV1"), Type:=xlFillDefault
Range("C1:IV1").Select
Rows("1:1").EntireRow.AutoFit
Range("C2").Select
ActiveCell.FormulaR1C1 = _
"=IF(ISERROR(LOOKUP(R[-1]C,extract!RC7:R[1500]C7,extract!RC14:R[1500]C14)),"""",LOOKUP(R[-1]C,extract!RC7:R[1498]C7,extract!RC14:R[1498]C14))"
Range("C2").Select
Selection.AutoFill Destination:=Range("C2:IV2"), Type:=xlFillDefault
Range("C2:IV2").Select
Range("C3").Select
ActiveCell.FormulaR1C1 = _
"=IF(ISERROR(LOOKUP(R[-2]C,extract!R[-1]C7:R[1497]C7,extract!R[-1]C9:R[1497]C9)),"""",LOOKUP(R[-2]C,extract!R[-1]C7:R[1497]C7,extract!R[-1]C9:R[1497]C9))"
Range("C3").Select
Selection.AutoFill Destination:=Range("C3:IV3"), Type:=xlFillDefault
Range("C3:IV3").Select
Range("C4").Select
ActiveCell.FormulaR1C1 = _
"=SUMPRODUCT((extract!R2C13:R1500C13=R[-1]C1)*(extract!R2C7:R1500C7=R1C)*(((R[-1]C2=""S"")*extract!R2C30:R1500C30)+((R[-1]C2=""E"")*extract!R2C22:R1500C22)))"
Range("C4").Select
Selection.AutoFill Destination:=Range("C4:C109"), Type:=xlFillDefault
Range("C4:C109").Select
Selection.AutoFill Destination:=Range("C4:IV109"), Type:=xlFillDefault
Range("C4:IV109").Select
=SI(ESTERREUR(INDEX(extract!$F$1:$G$1500;EQUIV(PETITE.VALEUR(extract!$F$1:$F$1500;COLONNE()-2);extract!$F$1:$F$1500;0);2));"";INDEX(extract!$F$1:$G$1500;EQUIV(PETITE.VALEUR(extract!$F$1:$F$1500;COLONNE()-2);extract!$F$1:$F$1500;0);2))
=SI(ESTERREUR(RECHERCHE(C1;extract!$G2:$G1502;extract!$N2:$N1502));"";RECHERCHE(C1;extract!$G2:$G1500;extract!$N2:$N1500))
SOMMEPROD((extract!$M$2:$M$1500=$A4)*(extract!$G$2:$G$1500=C$1)*((($B4="S")*extract!$AD$2:$AD$1500)+(($B4="E")*extract!$V$2:$V$1500)))
Re
Vois le # 21
Re
# 25
je croyais que la sequence etait
vidé ajouts Infos
#26
Tu pourrais essayer d'etre un peu plus precis S.T.P
Ligne 1 de quelle feuille ?
Quelle formule ?
Quelle macro ?
=SI(ESTERREUR(INDEX(extract!$F$1:$G$1500;EQUIV(PETITE.VALEUR(extract!$F$1:$F$1500;COLONNE()-2);extract!$F$1:$F$1500;0);2));"";INDEX(extract!$F$1:$G$1500;EQUIV(PETITE.VALEUR(extract!$F$1:$F$1500;COLONNE()-2);extract!$F$1:$F$1500;0);2))
ActiveCell.FormulaR1C1 = _
"=IF(ISERROR(INDEX(extract!R1C6:R1500C7,MATCH(SMALL(extract!R1C6:R1500C6,COLUMN()-2),extract!R1C6:R1500C6,0),2)),"""",INDEX(extract!R1C6:R1500C7,MATCH(SMALL(extract!R1C6:R1500C6,COLUMN()-2),extract!R1C6:R1500C6,0),2))"
Range("C1").Select
Selection.AutoFill Destination:=Range("C1:IV1"), Type:=xlFillDefault
Range("C1:IV1").Select