ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¸ê®ÆÂà¸m¨D§U«e½ú

[µo°Ý] ¸ê®ÆÂà¸m¨D§U«e½ú

¸ê®ÆÂà¸m¨D§U«e½ú,¦p¦óª½¦¡Âà¾î¦¡¤À¤W¤U¥b¦~,Àµ½Ð¥ý¶iÀ°¦£,·P®¦.

ª½¦¡Âà¾î¦¡2.rar (9.53 KB)

§ù¤p¥­

¦^´_ 1# dou10801

±Æ¯Zªí¦p¦ó®M¤Jªí®æ2_v1.zip (23.51 KB)

test

TOP

¦^´_ 1# dou10801

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Sub test()
Dim Arr, Brr(), i&, s%, k%, n%, x%
Arr = Range([a3], [c65536].End(3))
ReDim Brr(1 To UBound(Arr), 1 To 16)
For i = 1 To UBound(Arr)
    s = s + 1: k = k + 1
    For j = 1 To 3
        n = n + 1: Brr(n, k) = Arr(i, j)
    Next j
    If s = 16 Then
        x = x + 1: R = R + s
        n = R / 16 * 3 + x
        k = 0: s = 0
    Else
        If n < 4 Then n = 0 Else n = n - 3
    End If
Next
Range("h12").Resize((x + 1) * 4, 16) = Brr
End Sub

TOP

¦^´_ 2# singo1232001


¤j¤j±z¦n¡A¦pªG¸ê®Æ¨Ó·½¦b¦h¥[´X¦C¡Aµ²ªGÅã¥Ü·|¤£¤@¼Ë¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

TOP

¦³¥Xª¬ªpªº½d¨Ò¶Ü

TOP

¦^´_ 5# singo1232001


¦pªþ¥ó½Ð±z´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

±Æ¯Zªí¦p¦ó®M¤Jªí®æ2_v1.zip (23.77 KB)

TOP

Sub Âà¸m()
Dim Arr, Brr, C%(2), r%, i&, j%
ActiveSheet.UsedRange.Offset(, 7).EntireColumn.Delete
Arr = Range([a3], [c65536].End(3))
ReDim Brr(1 To 8, 1 To 200)
For i = 2 To UBound(Arr)
    r = IIf(Arr(i, 1) > 6, 1, 0):  C(r) = C(r) + 1
    For j = 1 To 3
        Brr(r * 4 + j, C(r)) = Arr(i, j)
    Next j
    If C(r) > C(2) Then C(2) = C(r)
Next i
With [h2].Resize(UBound(Brr), C(2))
     .Value = Brr
     .Borders.LineStyle = 1
     .ColumnWidth = 4
     .Font.Size = 14
End With
End Sub

Xl0000541.rar (13.97 KB)


================================

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 6# samwang

±Æ¯Zªí¦p¦ó®M¤Jªí®æ2_v2.zip (25.31 KB)

TOP

¦^´_ 9# singo1232001


# 3 ¼Ó¦^µª¡AÀ³¸Ó´N¬O±zªº»Ý¨D¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C
Sub test()
Dim Arr, Brr(), i&, s%, k%, n%, x%
Arr = Range([a3], [c65536].End(3))
ReDim Brr(1 To UBound(Arr), 1 To 16)
For i = 1 To UBound(Arr)
     s = s + 1: k = k + 1
     For j = 1 To 3
         n = n + 1: Brr(n, k) = Arr(i, j)
     Next j
     If s = 16 Then
         x = x + 1: R = R + s
         n = R / 16 * 3 + x
         k = 0: s = 0
     Else
         If n < 4 Then n = 0 Else n = n - 3
     End If
Next
Range("h2").Resize((x + 1) * 4, 16) = Brr
End Sub

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD