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

[µo°Ý] EXCEL ¼Ï¯Ã¤ÀªRªí ¦C¦L°ÝÃD¡C

[µo°Ý] EXCEL ¼Ï¯Ã¤ÀªRªí ¦C¦L°ÝÃD¡C

¤j®a¦n,·Q½Ð°Ý¤@¤U,§Ú¦³¤@­ÓEXCEL¼Ï¯Ã¤ÀªRªí,¦Ó§Ú¥­®É§â³o¨Ç¤ÀªRªí·|¦C¦L¥X¨Ó,
¿ï©w¤ÀªRªí¤¤ªº¬Y¤@­ÓÄæ¦ì,¨Ò¦p"Job no" Äæ, §Q¥ÎVBA ¿ï¾Ü¤§«á¦A¨C¤@­Ó¦C¦L¥X¨Ó¡C
¦ý¬O¦³­Ó°ÝÃD,·í§Ú¿ï¾Ü¨C¤@­Ó"Job no"«á ¥L´N­nªá®É¶¡¥h§äÁÙ¦³¨C±i¦C¦L¥X¨Ó¡C
½Ð°Ý¦³¨S¦³¤@­Ó¤èªk¯à«ö·Ó¹Ï1 ªº¨Ó·½(¤ÀªRªí®Ú¾Ú¹Ï1ªºJOB NO")¥h¦C¦L,,¦P®É¸`¬Ù¥L­n¥h§ä"job No'¦A¨C¤@±i¦C¦Lªº°ÝÃD¡C
§ä§¹¤§«á¤@¦¸©Ê¦C¦L¥X¨Ó,¦Ó¤£¬O¨C¤@±i³£§ä§¹¦A¦C¦L¡C
¦]¬°¸ê®Æªº¦C¼Æ¦³¾÷·|¨ì´X¤d,¦Ó"Job no"¸g¤ÀªRªí¾ã²z«á,¦³¾÷·|¹F¨ì1000­Ó,©Ò¥H­n½s1000±i,
¦ý¬O¦pªGVBA¥H"Job No"¨C±i¥h§ä©M¦C¦L´N·|ªá«Ü¦h®É¶¡,¤j¬ù­nªá30-45¤ÀÁé,¯à¤£¯à¦AÁYµu¤@¤U¡C
¥H¤U¬O§ÚªºVBA ¥N½X.³Â·Ð¬Ý¬Ý¯à§_§ó§ï¤@¤UVBA,ÁÂÁ¦U¦ì¡C
G1.jpg
2019-1-22 23:43

G2.jpg
2019-1-22 23:43

G3.jpg
2019-1-22 23:43

¥»©«³Ì«á¥Ñ quickfixer ©ó 2019-1-23 02:12 ½s¿è

¦^´_ 1# stephenlee

https://www.mobile01.com/topicdetail.php?f=511&t=5056987
³oÃä¬Ý¨ìªºµ{¦¡,¸Ì­±ªºa:a§ï¦¨b:b,»¡¤£©w¦X¥Î

TOP

¨Ó·½¸ê®Æªí°²¦p§Ú¦³10­ÓÄæ¦ìªº¸ê®Æ,¦Ó§Ú¨Ï¥Î¼Ï¯Ã¤ÀªRªí¥u¿ï¾Ü1,3,5,6,7,8 Ä檺Äæ¦ì¦WºÙ°µ¤ÀªRªí¥X¨Ó,¦P®É¦C¦L¥X¨Ó,¦Ó¤ÀªRªí¬O¥Î"Job no"¨Ó¿z¿ï¦C¦L,¦Ó§Ú¬O¤@©w»Ý­n¥Î¤ÀªRªí¨Ó¦C¦L,¦]¬°¬O¤½¥q©T©w®æ¦¡,¸ê®Æ¨Ó·½ªíªº"Job no"¤£¤@©w¬OG19000-01 ¶¶§Çªº,¦³¾÷·|¬O G19000-01 ¦C¦L§¹«á¦C¦LG19000-03,¤§«á¦A¦C¦LG19000-02 ³o¼Ë,©Ò¥H§Ú´N¨Ï¥Îcall print ¥h¿z¿ï®Ú¾Ú¨Ó·½¸ê®Æªíªº¶¶§Ç¥h¦C¦L,¤£¹L³o¼Ë¦]¬°¦³¹F¨ì1000­ÓG19000-1-1000, ©Ò¥H­n¿ï¾Ü1000¦¸©M¦C¦L1000±i,¦ý¦]¬°¥Ø«e¨Ï¥Î³o­Ó¤èªk«D±`ªá®É,©Ò¥H·Q½Ð±Ð¤j­ô,¯à¤£¯à¦b¤ÀªRªí¤¤¦C¦L¬ÛÃö"Job no"¦ý¬O­n®Ú¾Ú¨Ó·½¸ê®Æªíªº¶¶§Ç¨Ó¦C¦L,¦P®É¯àÁYµu®É¶¡,ÁÂÁ¡C

TOP

¦pªG¥H¤W¤Ó³Â·Ð,¨º¦pªG§Ú¦b¤ÀªRªí±Æ§Ç¦n,¦A¨C¤@±i¦C¦L¥X¨Ó,¦³¨S¦³¤°»ò¤èªk¥i¥HÁYµu¤@¤U®É¶¡©O,ÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD