[µo°Ý] «ö«ü©w¦¸¼Æ­«½Æ¼Æ¾Ú

shootingstar

¦U¦ì«e½ú¦n~§Ú¦³¤@±i¶µ¥Ø¤ÀÅu©³½Z¡A§Æ±æ«ö¦³°Ñ»P¶µ¥Ø¤ÀÅuªº¦¸¼Æ­«½ÆºK­nÄæ¨Ã±N¤ÀÅuª÷ÃB¶ñ¤J¡A

¤U¸ü (145.08 KB)
¦p¹Ï

¬Q¤Ñ 23:39

¡A½Ð°Ý¦bL3~N3¸Ó¦p¦ó¤U¤½¦¡¡AÁÂÁÂ

Andy2483

¦^´_ 1# shootingstar


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò,«á¾ÇÂǦ¹©«½m²ßVBA°}¦Cªº¤è®×,½Ð«e½ú°Ñ¦Ò

Option Explicit
Sub TEST()
Dim Brr, Crr(1 To 10000, 1 To 3), i&, j%, R&, T$
Brr = Range([I2], Cells(Rows.Count, 1).End(3))
For i = 2 To UBound(Brr)
   T = Brr(i, 1)
   For j = 2 To UBound(Brr, 2)
      If Val(Brr(i, j)) <> 0 Then
         R = R + 1
         Crr(R, 1) = T
         Crr(R, 2) = Brr(1, j)
         Crr(R, 3) = Val(Brr(i, j))
      End If
   Next
Next
Intersect(ActiveSheet.UsedRange.Offset(2, 11), [L:N]).ClearContents
If R = 0 Then Exit Sub
[L3:N3].Resize(R) = Crr
End Sub