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

[µo°Ý] ¿z¿ï«á¥[Á`

¨ü±Ð¤F,¨S¦³¦X¥Îªº¤u¨ã,·Q¿ìªk²Õ¦X....«ä¦Ò¤è¦V¤Ó«]­­,­n¥[±j¾Ç²ß

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2023-3-27 14:49 ½s¿è

¦^´_ 1# 0939875756


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾ÇÂǦ¹¥DÃD´ú¸Õ¦r¨åªº¯S©Ê,¾Ç²ß¨ì«Ü¦hª¾ÃÑ,«á¾ÇVBAªº¸Ñ¨M¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò
ÁÂÁ½׾Â,ÁÂÁ¦U¦ì«e½ú

°õ¦æ«e:


°õ¦æµ²ªG:


'¦r¨å¸Ìªº°}¦C»Ý­nÅܼƲ±¸Ë¥X¨Ó½s¿è,¦A©ñ¦^¦r¨å,¤~¦³®Ä
Option Explicit
Sub TEST()
Dim Y, i&, j&, °}¦C()
Set Y = CreateObject("Scripting.Dictionary")
Set Y(1) = Range([1B!I1], [1B!A1].End(xlDown))
Y(2) = Y(1): Y(5) = 1: °}¦C = Y(2)
For i = 2 To UBound(°}¦C)
   If °}¦C(i, 4) Like "RH*" And °}¦C(i, 5) = "A36" Then
      Y(5) = Y(5) + 1
      For j = 1 To UBound(°}¦C, 2)
         °}¦C(Y(5), j) = °}¦C(i, j)
      Next
      Y(0) = Y(0) + °}¦C(Y(5), 8)
   End If
Next
Y(2) = °}¦C
Workbooks.Add
[A1].Resize(Y(5), UBound(Y(2), 2)) = Y(2)
Cells(Y(5) + 1, 3) = "¤p­p"
Cells(Y(5) + 1, 8) = Y(0)
Cells.Columns.AutoFit
Set Y = Nothing: Erase °}¦C
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD