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

½Ð±Ð:¤@Ä椺¦³¦hµ§¸ê®Æ,¦p¦ó´£¨ú¯S©w­Èªº¸ê®Æ

½Ð±Ð:¤@Ä椺¦³¦hµ§¸ê®Æ,¦p¦ó´£¨ú¯S©w­Èªº¸ê®Æ

¦U¦ì¥ý¶i,¦³¤U¦Cªº°ÝÃD,¤£ª¾¯à¤£¯à¨ó§U¸Ñ¨M!!
¦p¹Ï:·Q°w¹ï"¤p§õ"³o­Ó¯S©w­È°µ¬°¯S©w­È,±N¤p§õªº¯S©w­È´£¥X,©ñ¸m¦b®Ç....

¦^´_ 1# b31978
¥i¸Ô¬Ý VBA »¡©ú
Filter ¨ç¼Æ  ¶Ç¦^¤@­Ó±q¹s¶}©lªº°}¦C¡A¸Ó°}¦C¥]§t°ò©ó«ü©w¿z¿ï·Ç«hªº¤@­Ó¦r¦ê°}¦Cªº¤l¶°¡C
Split ¨ç¼Æ   ¶Ç¦^¤@­Ó³¯¦C¯Á¤Þ±q¹s¶}©lªº¤@ºû°}¦C¡A¥¦¥]§t«ü©w¼Æ¥Øªº¤l¦r¦ê¡C
Replace ¨ç¼Æ ¶Ç¦^¤@­Ó¦r¦ê¡A¸Ó¦r¦ê¤¤«ü©wªº¤l¦r¦ê¤w³Q¨ú¥N¦¨¥t¤@¤l¦r¦ê¡A¨Ã¥B¨ú¥Nµo¥Íªº¦¸¼Æ¤]¬O«ü©wªº¡C
  1. Option Explicit
  2. Sub Ex()
  3.     Dim E As Range, A As Variant, i As Integer, B As String
  4.     For Each E In [AL12:AL26]  '½d³ò¤¤ªº¨C¤@­Ó¦¨­û(E)
  5.         i = 0
  6.         For Each A In Filter(Split(E, vbLf), "¤p§õ:", True)
  7.             'Miscellaneous ±`¼Æ vbLf -> Chr(10) : ´«¦æ¦r¤¸¡C
  8.             B = Replace(A, "¤p§õ:", "")
  9.             B = Replace(B, "PCS", "")
  10.             i = i + B
  11.         Next
  12.         E.Offset(, 1) = IIf(i <> 0, i, "") '¥kÃä²Ä 1 Äæ
  13.     Next
  14. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁÂ,§ì¯}¸£§ï¤F¦n¦h¤Ñ,ÁÙ¬O¤j¯«¼F®`....ÁÂÁÂ

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