Sub transfert()
Sheets("mediaire").Select
ActiveCell.SpecialCells(xlLastCell).Select
Range(Selection, Cells(1)).Select
For Each rw In Selection.Rows
ligne = rw.Row
If rw.Cells(ligne, 1) <> "" Then
rw.Copy Destination:=Worksheets(CStr(Sheets("mediaire").Cells(ligne, 25))).Cells(ligne, 1).EntireRow
End If
Next rw
End Sub