本帖最后由 yihaochu 于 2019-3-18 14:53 编辑
Sub 第三条审核()
t = Timer
Set d = CreateObject("scripting.dictionary")
arr = Sheet2.[a1].CurrentRegion
arr1 = Sheet3.[a1].CurrentRegion
For i = 1 To UBound(arr)
If arr(i, 3) <> 1 and arr(i, 3) <> 7 Then
For n = 1 To UBound(arr1)
If arr1(n, 1) = arr(i, 1) And arr1(n, 8) = arr(i, 2) And arr1(n, 4) Like "22*" Then
m = m + 1
Sheet1.Cells(m, 1) = arr1(n, 1)
Sheet1.Cells(m, 2) = arr1(n, 2)
Sheet1.Cells(m, 3) = arr1(n, 3)
Sheet1.Cells(m, 4) = arr(i, 2)
Sheet1.Cells(m, 5) = arr(i, 3)
Sheet1.Cells(m, 6) = arr1(n, 4)
Sheet1.Cells(m, 7) = arr1(n, 6)
End If
Next
End If
Next
MsgBox "{汇总计时:" & Timer - t & "秒"
End Sub
自己编的第三条的审核,表中数据只是一部分,实际问卷数据有1000多条,账页数据有10万条以上 |