Private Sub CommandButton1_Click()
Dim arrhz, arrdg, arrtp, sht
Dim lngRf As Long, lngRt As Long, bytsh As Byte
With Sheets("汇总表")
.Range("F4:F" & .Range("i65536").End(xlUp).Row).ClearContents
arrhz = .Range("A4:I" & .Range("i65536").End(xlUp).Row)
arrdg = .Range("F4:F" & .Range("i65536").End(xlUp).Row)
For lngRf = LBound(arrdg) To UBound(arrdg)
For Each sht In Worksheets
If sht.Name <> "汇总表" Then
arrtp = sht.Range("A4:I" & sht.Range("i65536").End(xlUp).Row)
For lngRt = LBound(arrtp) To UBound(arrtp)
If arrhz(lngRf, 2) = arrtp(lngRt, 2) And _
arrhz(lngRf, 3) = arrtp(lngRt, 3) And _
arrhz(lngRf, 7) = arrtp(lngRt, 7) And _
arrhz(lngRf, 9) = arrtp(lngRt, 9) Then
arrdg(lngRf, 1) = arrdg(lngRf, 1) + arrtp(lngRt, 6)
End If
Next lngRt
End If
Next sht
Next lngRf
.Range("F4:F" & .Range("i65536").End(xlUp).Row) = arrdg
End With
End Sub
汇总表.rar
(22.2 KB, 下载次数: 6)