- ©«¤l
- 41
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-4-1
- ³Ì«áµn¿ý
- 2016-2-17
|
¦^´_ 1# dnadark
°Ñ¦Ò¬Ý¬Ý!!!- Sub test()
- Dim arr: arr = Worksheets("¤u§@ªí1").[c1:e15]
- Dim i, j, k: i = 1: k = 2
- With Worksheets("¤u§@ªí2")
- '.UsedRange.Clear
- .Cells(1, 1) = arr(1, 1)
- For j = 2 To 15
- If arr(j, 1) <> arr(j - 1, 1) Then
- i = i + 1: k = 2: j = j + 1: .Cells(i, 1) = arr(j, 1)
- End If
- .Cells(i, k) = arr(j, 2)
- .Cells(i, k + 1) = arr(j, 3)
- k = k + 2
- Next j
- End With
- End Sub
½Æ»s¥N½X |
|