Please I want a better vba macro that can do the same job as the one below however the one below is extremely slow. thank you
Sub EARNINGSEQUENCING()
For i = 38 To 665
For j = 3 To 9986
If Worksheets("EARNINGSEQ").Cells(i, 4) = 1991 And _
Worksheets("EARNINGSEQ").Cells(i, 4) = Worksheets("Sheet1").Cells(j, 16) And _
Worksheets("EARNINGSEQ").Cells(i, 7) = Worksheets("Sheet1").Cells(j, 3) And _
Worksheets("EARNINGSEQ").Cells(i, 8) = Worksheets("Sheet1").Cells(j, 17) Then
Worksheets("EARNINGSEQ").Cells(i, 10) = Worksheets("Sheet1").Cells(j, 14)
Worksheets("EARNINGSEQ").Cells(i, 11) = Worksheets("Sheet1").Cells(j + 1, 14)
Worksheets("EARNINGSEQ").Cells(i, 12) = Worksheets("Sheet1").Cells(j + 2, 14)
Worksheets("EARNINGSEQ").Cells(i, 13) = Worksheets("Sheet1").Cells(j + 3, 14)
End If
If Worksheets("EARNINGSEQ").Cells(i, 4) = 1992 And _
Worksheets("EARNINGSEQ").Cells(i, 4) = Worksheets("Sheet1").Cells(j, 16) And _
Worksheets("EARNINGSEQ").Cells(i, 7) = Worksheets("Sheet1").Cells(j, 3) And _
Worksheets("EARNINGSEQ").Cells(i, 8) = Worksheets("Sheet1").Cells(j, 17) Then
Worksheets("EARNINGSEQ").Cells(i, 10) = Worksheets("Sheet1").Cells(j, 14)
Worksheets("EARNINGSEQ").Cells(i, 11) = Worksheets("Sheet1").Cells(j + 1, 14)
Worksheets("EARNINGSEQ").Cells(i, 12) = Worksheets("Sheet1").Cells(j + 2, 14)
Worksheets("EARNINGSEQ").Cells(i, 13) = Worksheets("Sheet1").Cells(j + 3, 14)
End If
If Worksheets("EARNINGSEQ").Cells(i, 4) = 1993 And _
Worksheets("EARNINGSEQ").Cells(i, 4) = Worksheets("Sheet1").Cells(j, 16) And _
Worksheets("EARNINGSEQ").Cells(i, 7) = Worksheets("Sheet1").Cells(j, 3) And _
Worksheets("EARNINGSEQ").Cells(i, 8) = Worksheets("Sheet1").Cells(j, 17) Then
Worksheets("EARNINGSEQ").Cells(i, 10) = Worksheets("Sheet1").Cells(j, 14)
Worksheets("EARNINGSEQ").Cells(i, 11) = Worksheets("Sheet1").Cells(j + 1, 14)
Worksheets("EARNINGSEQ").Cells(i, 12) = Worksheets("Sheet1").Cells(j + 2, 14)
Worksheets("EARNINGSEQ").Cells(i, 13) = Worksheets("Sheet1").Cells(j + 3, 14)
End If
If Worksheets("EARNINGSEQ").Cells(i, 4) = 1994 And _
Worksheets("EARNINGSEQ").Cells(i, 4) = Worksheets("Sheet1").Cells(j, 16) And _
Worksheets("EARNINGSEQ").Cells(i, 7) = Worksheets("Sheet1").Cells(j, 3) And _
Worksheets("EARNINGSEQ").Cells(i, 8) = Worksheets("Sheet1").Cells(j, 17) Then
Worksheets("EARNINGSEQ").Cells(i, 10) = Worksheets("Sheet1").Cells(j, 14)
Worksheets("EARNINGSEQ").Cells(i, 11) = Worksheets("Sheet1").Cells(j + 1, 14)
Worksheets("EARNINGSEQ").Cells(i, 12) = Worksheets("Sheet1").Cells(j + 2, 14)
Worksheets("EARNINGSEQ").Cells(i, 13) = Worksheets("Sheet1").Cells(j + 3, 14)
End If
If Worksheets("EARNINGSEQ").Cells(i, 4) = 1995 And _
Worksheets("EARNINGSEQ").Cells(i, 4) = Worksheets("Sheet1").Cells(j, 16) And _
Worksheets("EARNINGSEQ").Cells(i, 7) = Worksheets("Sheet1").Cells(j, 3) And _
Worksheets("EARNINGSEQ").Cells(i, 8) = Worksheets("Sheet1").Cells(j, 17) Then
Worksheets("EARNINGSEQ").Cells(i, 10) = Worksheets("Sheet1").Cells(j, 14)
Worksheets("EARNINGSEQ").Cells(i, 11) = Worksheets("Sheet1").Cells(j + 1, 14)
Worksheets("EARNINGSEQ").Cells(i, 12) = Worksheets("Sheet1").Cells(j + 2, 14)
Worksheets("EARNINGSEQ").Cells(i, 13) = Worksheets("Sheet1").Cells(j + 3, 14)
End If
Next j
Next i
End Sub
Bookmarks