|
- Sub 数据核对()
- Dim ARR, BRR, CRR(), I As Integer, J As Integer, K As Integer, MAXROW As Integer, X As Byte
- MAXROW = Range("A1").End(xlDown).Row
- ARR = Range("A2:F" & MAXROW)
- BRR = Range("G2:L" & MAXROW)
- ReDim CRR(1 To UBound(ARR))
- For K = 1 To UBound(ARR)
- For I = 1 To UBound(ARR)
- If ARR(I, 1) = BRR(K, 1) And ARR(I, 2) = BRR(K, 2) And ARR(I, 3) = BRR(K, 3) And ARR(I, 4) = BRR(K, 4) And ARR(I, 5) = BRR(K, 5) And ARR(I, 6) = BRR(K, 6) Then
- CRR(K) = 1
- GoTo 1:
- Else
- CRR(K) = 0
- End If
- Next
- 1:
- Next
- Range("M2").Resize(MAXROW) = Application.Transpose(CRR)
- End Sub
复制代码
用VBA做了一个。 |
|