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

[µo°Ý] ¥¿½T°õ¦æµ{¦¡½Xªº°ÝÃD

[µo°Ý] ¥¿½T°õ¦æµ{¦¡½Xªº°ÝÃD

¤£¦n·N«ä¡A¹ïVBA»yªk§¹¥þ¬Oªù¥~º~¡A
¸Û½Ð¦U¦ì¤j¤j«ü±Ð©MÀ°¦£¡CÁÂÁÂ!

§Úªº°ÝÃD¡J
1_¥DÀɪº¦C7~¦C14ªºµ{¦¡½XÀ³¸Ó¦p¦ó¦A¼W­×?
¥H§Q¯à¥¿½T°õ¦æ¦C16~¦C82ªºWith Sheets(1) (§Y«e3¤j)©MWith Sheets(2) (§Y«e3¤p)µ{¦¡½X¡C

2_¥DÀɦC7~¦C14¼W­×«áªºµ{¦¡½X¡A·Ð½Ðµy¥[¤å¦rµù¸Ñ¡C

´ú¸Õªþ¥óÀɮסJ ´ú¸Õªþ¥óÀÉ®×.rar (129.59 KB)

¦^´_ 1# ziv976688
1¼Óªº´ú¸Õªþ¥óÀɮפ£©P¥þ~
§ó·s´ú¸Õªþ¥óÀɮסJ
´ú¸Õªþ¥óÀÉ®×(V1).rar (168.85 KB)
PS¡J
µLAns=¥Ø«e¶]¥XªºÀÉ®×
¦³Ans=¥¿½Tµª®×ªº»Ý¨DÀÉ®×

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-14 16:23 ½s¿è

¸É¥R»¡©ú :
¥Ø«eªº§xÂZ¬O¦b~
1_¶]¥Xªºµª®×¥u·|¸¨¦b³Q´ú¸ÕÀÉ®×·í¤U¶}±Ò®Éªº¤u§@ªí¡A¤]´N¬O·íÀɮ׶}±Ò®É¡A¬OSheet1¡A·í¤Uªºµª®×¡A´N¸¨¦b¸ÓSheet1¡F¦pªG·íÀɮ׶}±Ò®É¡A¬OSheet2¡A·í¤Uªºµª®×¡A´N¸¨¦b¸ÓSheet2¡C
2_µª®×³£¬O¶]¥X"«e3¤p"ªº¤½¦¡­È¡C
3_¦]¬°¦UÀɮתº¤u§@ªí.Name¡A³£¤£¬Û¦P¡A©Ò¥H§Ú¥u¯à¥HSheet1©MSheet2¨Ó°Ï¤À~¦ýÅãµM¬OµL®Ä^^"

¥»ÃD»Ý¨D~
¥u­n¯àÅý¦C16~¦C82ªºµ{¦¡½X¯à¥¿½T¶¶ºZªº¶]¥X­È§Y¥i¡A
½Ð¤£­n§ó§ï¦UÀx¦s®æ¿é¤J¤½¦¡ªº»yªk¡A
¦]¬°·íªí®æªº®æ¦¡§ïÅܮɡA¤Ó°ª¶¥ªº»yªk¡A¤£¤~ªº§Ú®£µLªkÂà¤Æ®M¥Î^^"

¥H¤W  ½Ð¦U¦ì¤j¤j«ü±Ð!ÁÂÁÂ!

TOP

¨Ï¥Î¦Û­q¨ç¼Æ, ¯à¥Î«h¥Î:
´ú¸Õªþ¥óÀÉ®×_1.rar (176.67 KB)

TOP

¦^´_ 4# ­ã´£³¡ªL
­ã´£ª©¥D:±z¦n!
·PÁ½ç±Ð^^
¤£¤~ºCºC¬ã¨s~·P®¦.....

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD