|
试一下这个代码看看。。- Sub Ax()
- Dim Arr, Brr, Crr, Abz$, Bbz$
- Arr = Sheets("年初").[a1].CurrentRegion
- Brr = Sheets("报告期").[a1].CurrentRegion
- ReDim Crr(1 To UBound(Brr) - 1, 1 To 2)
- For i = 2 To UBound(Brr)
- Bbz = Brr(i, 2) & Brr(i, 3) & Brr(i, 4) & Brr(i, 11)
- For j = 2 To UBound(Arr)
- Abz = Arr(j, 2) & Arr(j, 3) & Arr(j, 4) & Arr(j, 11)
- If Bbz = Abz Then flag = 1
- Next
- If flag = 1 Then
- Crr(i - 1, 1) = "正常"
- Else
- Crr(i - 1, 2) = "新增"
- End If
- flag = 0
- Next
- Sheets("报告期").[ap2].Resize(i - 2, 2) = Crr
- End Sub
复制代码 |
|