- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 73
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-3-29
|
¦^´_ 1# s7659109
VBA»²§U¨Óªº®e©ö- Sub ex()
- Dim Ay(2), Ary()
- Set dic = CreateObject("Scripting.Dictionary")
- With Sheets("Á`ªí")
- For Each a In .Range(.[B3], [B3].End(xlDown))
- If IsEmpty(dic(a.Value)) Then
- ar = Array(a.Value, "", "¶i³f", "", "", "¥X³f", "", "")
- Ay(0) = ar
- Ay(1) = .[A2:H2].Value
- Ay(2) = a.Offset(, -1).Resize(, 8).Value
- dic(a.Value) = Ay
- Else
- Ary = dic(a.Value)
- ReDim Preserve Ary(UBound(Ary) + 1)
- Ary(UBound(Ary)) = a.Offset(, -1).Resize(, 8).Value
- dic(a.Value) = Ary
- End If
- Next
- End With
- For Each ky In dic.keys
- With Sheets(ky)
- .[A1].Resize(UBound(dic(ky)) + 1, 8) = Application.Transpose(Application.Transpose(dic(ky)))
- .Cells(.Rows.Count, 1).End(xlUp).Offset(1) = "¦Xp"
- .Cells(.Rows.Count, 8).End(xlUp).Offset(1) = "=SUM(R1C:R[-1]C)"
- End With
- Next
- End Sub
½Æ»s¥N½X |
|