1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Sub refer()
Dim i As Long, k As Long, l As Long
Dim j As Integer
application.screenupdating=false
l = 2
For j = 3 To 5
For k = 2 To Sheets(j).Range("A2").End(xlDown).Row
For i = 2 To Sheets(1).Range("E1").End(xlDown).Row
If Sheets(j).Cells(k, 1) = Sheets(1).Cells(i, 5) Then
GoTo ici
End If
Next i
Sheets(j + 3).Cells(l, 1) = Sheets(j).Cells(k, 1)
Sheets(j + 3).Cells(l, 2) = Sheets(j).Cells(k, 2)
Sheets(j).Cells(k, 1)=""
Sheets(j).Cells(k, 2)=""
l = l + 1
ici:
Next k
l = 2
Next j
application.screenupdating=true
End Sub |