|
发表于 2016-5-5 20:56
|
显示全部楼层
本楼为最佳答案
Sub Click()
Dim A, B, i, j, x, str
A = Range("a1").CurrentRegion
ReDim B(2 To UBound(A, 2))
x = [l1]
For i = 2 To UBound(A)
If A(i, 1) = x Then
For j = 2 To UBound(A, 2)
B(j) = B(j) + A(i, j)
Next j
End If
Next i
For j = 2 To UBound(B)
If B(j) Then str = str & vbCrLf & A(1, j) & ":" & B(j)
Next j
[m1] = Mid(str, 3)
End Sub
汇总非零信息至一个单元格内2.rar
(8.98 KB, 下载次数: 20)
|
|