Private Sub Worksheet_Change(ByVal Target As Range)
Dim L As Long
Dim Col As Byte
Select Case Target.Value
Case 1: Col = 2
Case 2: Col = 4
Case 3: Col = 6
Case Else: Col = 1
End Select
If Not Application.Intersect(Target, Range('A:A')) Is Nothing Then
With Sheets('Feuil2')
L = .Range('A65536').End(xlUp).Row + 1
.Range('A' & L) = Me.Cells(Target.Row, Col)
End With
End If
End Sub