Private Sub CommandButton1_Click()
For Each cel In Sheets("Feuil1").Range("A:A").SpecialCells(xlCellTypeConstants)
lg = Sheets("Feuil3").Range("A" & Rows.Count).End(xlUp).Row + 1
Sheets("Feuil3").Range("A" & lg) = cel.Value
Next
For Each cel In Sheets("Feuil2").Range("A:A").SpecialCells(xlCellTypeConstants)
lg = Sheets("Feuil3").Range("A" & Rows.Count).End(xlUp).Row + 1
Sheets("Feuil3").Range("A" & lg) = cel.Value
Next
End Sub