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

ªí³æ¤ñ¸û

ªí³æ¤ñ¸û

½Ð°Ý¥i§_¥Î¤½¦¡ªì¨B±o¥X¨â­Óªí³æ (¯»¬õ¦â³¡¥÷) ªº¤º®e¦³§_®t²§,
¥i§Q¥Î®ÇÃä³æ¶µ¤ñ¸ûµ²ªG
½Ð¦h¦h«ü±Ð

ªí³æ¤ñ¸û.zip (9.7 KB)

®t²§¬O§_¥]¬A¶¶§Ç?
¤£¹L§A³o¨â­Óªíªø«×³£¤£¦P,¤@¬Ý´N¤£¤@¼Ë¤F§a.

TOP

®t²§¤£¥]¬A¬O§_¶¶§Ç,
¥i¥u¤ñ¸ûDiff Äæ¦ì¦³§_¥X²{¤£¬O"0"

TOP

http://blog.xuite.net/hcm19522/twblog/470352497

TOP

¦^´_ 1# enoch


    enoch ±ß¤W¦n

A¸Ñ
1.±NMaterialAÄæ¦ì ©M MaterialBÄæ¦ì «~¶µ¡A­«·s¾ã²z©ñ¦b¬Û¦PÄæ¦ì
2.§Q¥Î¡i²¾°£­«½Æ¡jªº¥\¯à¡A²£¥Í°ß¤@­È
3. VLOOK¨ç¼Æ ±o¥XQtyA©MQtyB
4. ¨Ï¥Î IF¨ç¼Æ Äæ¦ì¤ñ¸û¼Æ­È¬O§_¬Û¦P

B¸Ñ
1.Äæ¦ì­«·s¾ã²z¡÷ Material/ID/Qty
2.§Q¥Î¼Ï¯Ã¤ÀªRªí Àò±o¼Æ¾Ú
3.¨Ï¥Î IF¨ç¼Æ Äæ¦ì¤ñ¸û¼Æ­È¬O§_¬Û¦P

ÁÂÁÂ~

ªí³æ¤ñ¸û-TEST.zip (53.26 KB)

«¢Åo, §A¦n¶Ü?!¡@°J¤ß·PÁÂ.¡@¬Ã­«¦A¨£.¡@´Á«Ý¦A¬Û³{.

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD