|
本帖最后由 qh8600 于 2014-12-29 19:01 编辑
老张附件中少了个2012-1-3,我已加上- Sub demo()
- Dim ar, re, br(), d, i, m, j, x, n
- ar = Range("a2:d" & Cells(Rows.Count, 1).End(3).Row)
- Set d = CreateObject("Scripting.Dictionary")
- re = Range("g3:am3")
- For i = 1 To UBound(ar)
- d(ar(i, 2)) = ""
- Next
- m = d.Keys
- ReDim br(1 To d.Count, 1 To UBound(re, 2))
- For x = 1 To d.Count
- n = n + 1
- For i = 1 To UBound(ar)
- If ar(i, 2) = m(x - 1) Then
- br(n, 1) = ar(i, 1)
- br(n, 2) = ar(i, 2)
- For j = 3 To UBound(br, 2)
- If ar(i, 3) = re(1, j) Then
- br(n, j) = "'" & ar(i, 4)
- End If
- Next
- End If
- Next
- Next
- Range("g4").Resize(UBound(br), UBound(br, 2)).ClearContents
- Range("g4").Resize(UBound(br), UBound(br, 2)) = br
- End Sub
复制代码 附件楼下
|
|