- ©«¤l
- 1425
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1449
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-4-16
|
¥»©«³Ì«á¥Ñ Andy2483 ©ó 2022-11-25 15:45 ½s¿è
¦^´_ 7# jsc0518
ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾ÇÂǦ¹©«½m²ß°}¦C»P¦r¨å,½Ð¦U¦ì«e½ú«ü¥¿¨Ã«ü¾É!ÁÂÁÂ
°õ¦æ«e:
°õ¦æµ²ªG:
¤ß±oµù¸Ñ¦p¤U:
Option Explicit
Sub ½m²ß_°}¦C»P¦r¨å()
Dim Brr, i&, Y
'¡ô«Å§iÅܼÆ
Set Y = CreateObject("Scripting.Dictionary")
'¡ô¥OY ¬O¦r¨å
Brr = Range([¤u§@ªí1!A2], [¤u§@ªí1!A65536].End(3))
'¡ô¥OBrr¬O¤Gºû°}¦C! ˤJ[A2]¨ì AÄæ³Ì«á¤@Ó¦³¤º®eÀx¦s®æªºÈ
For i = 1 To UBound(Brr)
'¡ô³]¶¶°j°é! ±q1 ¨ì Brr°}¦CÁa¦V¦C¸¹
Y(i) = Split(Brr(i, 1), "/")
'¡ô¥O¦r¨å¸Ë¤J°j°é¼Æªºkey,item¬O¤@ºû°}¦C(¥Î "/"²Å¸¹©î¸Ñ °}¦C°j°é¦r¦ê)
Next
[C5].Resize(Y.Count, 5) = Application.Transpose(Application.Transpose(Y.items))
'¡ô±q[C5]ÂX®i¦V¤UY¦r¨å¸Ìªºkey¼Æ¶q¦C¼Æ,¦V¥kÂX®i5Ä檺½d³ò,
'¶K¤JY¦r¨åitemÂà¸m¨â¦¸ªºÈ
Set Y = Nothing
Set Brr = Nothing
End Sub |
|