也不知道对不对,我就把数据写在下面了,没有去删除你原有多余的数据,万一删错了更麻烦。
Application.ScreenUpdating = False
hs = 25
Rows(hs & ":" & [b10000].End(3).Row).ClearContents
For i = 4 To 5
ls = 77
For k = 1 To 5
s1 = Cells(i, k)
js = 0
For j = 2 To 7
For l = 1 To 12
If Trim(Cells(i, j)) = Trim(Cells(i, 76 + l + (k - 1) * 12)) Then
js = js + 1
End If
Next l
Next j
For ss = 2 To 7
Cells(hs, ss) = Cells(i, ss)
Next ss
If js <= 1 Then
For l = 1 To 12
Cells(hs, ls) = Cells(i, 76 + l + (k - 1) * 12)
ls = ls + 1
Next l
End If
Next k
hs = hs + 1
Next i
Application.ScreenUpdating = True