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

[µo°Ý] ¦P®Éº¡¨¬¦h­Ó±ø¥óªº¼gªk(¤w¸Ñ¨M)

[µo°Ý] ¦P®Éº¡¨¬¦h­Ó±ø¥óªº¼gªk(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ arcticfox ©ó 2011-5-6 14:25 ½s¿è

¦U¦ì¤j¤j¦n
¤p§Ì­è±µÄ²VBA¤£¤[
³Ìªñ¦b³]­p­q³æºÞ²zªí
¤£¹L¹J¨ì¤@­Ó°ÝÃD,
´N¬OÃö©ó¦P®Éº¡¨¬3­Ó±ø¥ó¥H¤Wªº¼gªk

If ¥i¦P®Éº¡¨¬2­Ó
¦ý¬Oºô¤W¬d¤F³\¤[
´N¬O¨S¦³§ä¨ì¦P®Éº¡¨¬¤T­Ó±ø¥óªº¼gªk

§Úªº»Ý¨D¦p¤U:

¦b·s¼W­q³æ®É, ¬°ÁקK­«½Æ
©Ò¥H§Ú»Ý­n¦P®É³]©w, «È¤á, ­q³æ¸¹, «~¦W, §@¬°±ø¥ó¨Ì¾Ú
¬ÛÃöÀɮ׸Ԩ£ªþ¥ó
ÁÂÁÂ.:L

«È¤á­q³æ_¼Ë«~»P³ø»ùºÞ²z(Beta).zip (30.07 KB)

¼Ó¥D±z­nªº®ÄªG¬O¤°»ò...
²Å¦X  «È¤á ©M ­q³æ ¤Î «~¦W? ¦b­þÃä°µ¨Mµ¦?

TOP

¦^´_ 2# mark15jill


  Ops §Ú¬Oª½±µ¼g¦bªí³æ±±¨î¨ºùØ­±, ©Ò¥H¼Ò²Õ¸Ì­±¨S¦³
§Ú¥D­n¥Øªº¬OÁקK¿é¤Jªº¸ê®Æ²£¥Í­«½Æ
¨Ï¥ÎªÌ¦pªG¹ï¸Ü®Ø¤¤¿é¤Jªº¸ê®Æ, ¦P®É­«½Æ¤F¬ö¿ýªí³æªº "«È¤á", "²£«~", "PO¸¹½X"¶µ¥Ø
«h§iª¾¤w¸g¿é¤J¹L, ©Î¬O­q³æ¸¹½X­«½Æ¤§Ãþªº

¥t¥~, §Ú­è­è¤~µo²{, ¦]¬°«á­±¤S­×§ï¤F¤u§@ªí¦WºÙ
§Ñ°O§âVBAªº¤@°_­×§ï, «Ü©êºp.

TOP

With Sheets("¾P°â¾ú¥v¬ö¿ý")
¨S³o­Óªí

TOP

¦^´_ 4# chin15


À³¸Ó¬° "­q³æ¬ö¿ý"
·íªì­×§ï®É¨S§ï¨ì, ¦A³Â·Ð, ÁÂÁÂ

TOP

³o¼Ë¶Ü¡H
If Not Customer Is Nothing Or not PO Is Nothing Or not Model Is Nothing Then

TOP

¦^´_ 6# chin15


­è­è¸Õ¤F¤@¤U
ÁÂÁ¤j¤j, §ïAnd ´N¥i¥H¤F

.......¬O§Ú¤¤¨¸¶Ü
©ú©ú§Ú¤@¶}©l´N¬O·ÓµÛ¹³¤j¤j³o¼Ë§Ë¤F¨â­ÓAnd
´N¬O¨S¿ìªk°õ¦æ.......
µ²ªG­è­èPO§Aªº¤W¥h, §ïAnd ´N¥i¥H°õ¦æ.....
®`§Ú°±¤F¦n¤[:'(

ÁÂÁ°Õ

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD