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
| Sub Outil_consolider()
'
' Outil_consolider Macro
'
'
ActiveWindow.SmallScroll Down:=6
Range("C8:E40").Select
ActiveWorkbook.Names.Add Name:="SV10070", RefersToR1C1:= _
"='BTT - Code panne - SV10070'!R8C3:R40C5"
Sheets("BTT - Code panne - SV20070").Select
Range("C8:E41").Select
ActiveWorkbook.Names.Add Name:="SV20070", RefersToR1C1:= _
"='BTT - Code panne - SV20070'!R8C3:R41C5"
Sheets("BTT - Code panne - SV50070").Select
ActiveWindow.SmallScroll Down:=6
Range("C8:E41").Select
ActiveWorkbook.Names.Add Name:="SV50070", RefersToR1C1:= _
"='BTT - Code panne - SV50070'!R8C3:R41C5"
ActiveWindow.ScrollWorkbookTabs Sheets:=-1
Sheets("BTT - Code panne - SV60070").Select
Range("C8:E30").Select
ActiveWorkbook.Names.Add Name:="SV60070", RefersToR1C1:= _
"='BTT - Code panne - SV60070'!R8C3:R30C5"
ActiveWindow.ScrollWorkbookTabs Sheets:=-1
Sheets("BTT - Code panne - RHONE").Select
Range("C8:E50").Select
ActiveWorkbook.Names.Add Name:="RHONE", RefersToR1C1:= _
"='BTT - Code panne - RHONE'!R8C3:R50C5"
ActiveWindow.ScrollWorkbookTabs Sheets:=-1
Sheets("Total").Select
Range("D8").Select
Selection.Consolidate Sources:=Array( _
"'C:\Users\PASCAL-D\Desktop\Comparatif Panne BTT 2014 - 2013.xls'!RHONE", _
"'C:\Users\PASCAL-D\Desktop\Comparatif Panne BTT 2014 - 2013.xls'!SV10070", _
"'C:\Users\PASCAL-D\Desktop\Comparatif Panne BTT 2014 - 2013.xls'!SV20070", _
"'C:\Users\PASCAL-D\Desktop\Comparatif Panne BTT 2014 - 2013.xls'!SV50070", _
"'C:\Users\PASCAL-D\Desktop\Comparatif Panne BTT 2014 - 2013.xls'!SV60070"), _
Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False
Columns("D:D").EntireColumn.AutoFit
Columns("E:E").EntireColumn.AutoFit
Columns("F:F").EntireColumn.AutoFit
End Sub |
Partager