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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129
|
Global FeuillePrecedente As String
Sub Aller()
FeuillePrecedente = ActiveSheet.Name
End Sub
Sub RetourFeuil()
Sheets(FeuillePrecedente).Select
End Sub
Sub TabPrix()
Dim ws As Worksheet
Set ws = Sheets("Feuil3")
If (FeuillePrecedente = "Feuil5") Then
ws.Columns("Z").Delete
ws.Columns("AA").Delete
Sheets("Feuil5").Columns("Z").Copy ws.Range("AA1")
Sheets("Feuil5").Columns("H").Copy
ws.Range("Z1").PasteSpecial Paste:=xlPasteValues
ws.Columns("Z:Z").EntireColumn.AutoFit
ws.Range("Z1:Z7").ClearContents
ws.Select
ws.Range("AA50").End(xlUp).Select
Do
If IsEmpty(ActiveCell) Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(-1, 0).Select
Loop Until ActiveCell.Row = 1
Range("Z2:AA18").Sort Key1:=Range("AA2"), Order1:=xlDescending, header:=xlNo, Orientation:=xlTopToBottom
Range("AA19").Value = Range("AA2").Value
Range("AA2").EntireRow.Delete
End If
If (FeuillePrecedente = "Feuil6") Then
ws.Columns("Z").Delete
ws.Columns("AA").Delete
Sheets("Feuil6").Columns("Z").Copy ws.Range("AA1")
Sheets("Feuil6").Columns("H").Copy
ws.Range("Z1").PasteSpecial Paste:=xlPasteValues
ws.Columns("Z:Z").EntireColumn.AutoFit
ws.Range("Z1:Z7").ClearContents
ws.Select
ws.Range("AA50").End(xlUp).Select
Do
If IsEmpty(ActiveCell) Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(-1, 0).Select
Loop Until ActiveCell.Row = 1
Range("Z2:AA18").Sort Key1:=Range("AA2"), Order1:=xlDescending, header:=xlNo, Orientation:=xlTopToBottom
End If
If (FeuillePrecedente = "Feuil9") Then
ws.Columns("Z").Delete
ws.Columns("AA").Delete
Sheets("Feuil9").Columns("Z").Copy ws.Range("AA1")
Sheets("Feuil9").Columns("H").Copy
ws.Range("Z1").PasteSpecial Paste:=xlPasteValues
ws.Columns("Z:Z").EntireColumn.AutoFit
ws.Range("Z1:Z7").ClearContents
ws.Select
ws.Range("AA50").End(xlUp).Select
Do
If IsEmpty(ActiveCell) Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(-1, 0).Select
Loop Until ActiveCell.Row = 1
Range("Z2:AA18").Sort Key1:=Range("AA2"), Order1:=xlDescending, header:=xlNo, Orientation:=xlTopToBottom
End If
If (FeuillePrecedente = "Feuil10") Then
ws.Columns("Z").Delete
ws.Columns("AA").Delete
Sheets("Feuil10").Columns("Z").Copy ws.Range("AA1")
Sheets("Feuil10").Columns("H").Copy
ws.Range("Z1").PasteSpecial Paste:=xlPasteValues
ws.Columns("Z:Z").EntireColumn.AutoFit
ws.Range("Z1:Z7").ClearContents
ws.Select
ws.Range("AA50").End(xlUp).Select
Do
If IsEmpty(ActiveCell) Then
ActiveCell.EntireRow.Delete
End If
ActiveCell.Offset(-1, 0).Select
Loop Until ActiveCell.Row = 1
Range("Z2:AA18").Sort Key1:=Range("AA2"), Order1:=xlDescending, header:=xlNo, Orientation:=xlTopToBottom
End If
End Sub |
Partager