µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ½Ð±Ð vba vlookup
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
½Ð±Ð vba vlookup
198188
µoµu®ø®§
¥[¬°¦n¤Í
198188
·í«eÂ÷½u
UID
11471
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ª÷¿ú
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
290 ¤p®É
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
°ª¤¤¥Í
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2012-12-6 11:52
|
¥u¬Ý¸Ó§@ªÌ
½Ð±Ð vba vlookup
Desktop.rar
(468.45 KB)
¤U¸ü¦¸¼Æ: 4
2012-12-6 11:45
½Ð°Ý¥i§_¦boutstanding payment¤ºvlookup payment report
¦pªGpayment report HÄæ¹F¨ì95%©Î¥H¤W¤ÎKÄ檺¤é´Á¬O·í¤éªºSO#¡A¦Ó¦boutstanding payment ¨S¦³³oÓSO#(order AÄæ¡^¡A´N§âpayment report ªºSO#copy¦boutstanding payment AÄæ(ORDER)ªº³Ì«á¤@µ§¸ê®Æ¤§¤U¡C(¨âÓexcelªº¸ê®Æ·|¤£°±ªº¼W¥[¸ê®Æ¡A©Ò¥H¨S¦³©T©wªº¤@¦C¬O³Ì«á¤@µ§¸ê®Æ¡^
¼Ó¥D¼ö©«
½Ð¨D§ï¨}µ{¦¡
½Ð°ÝVBA ªºµ{¦¡¦³¨S¦³¥i¥H¿ë»{¬YÓÀx¦s®æ¤º
¥X²{RUN-TIME ERROR '9': SUBSCRIPT OUT OF
¸óÄæ¹ï¤ñ
½Ð°ª¤HÀ°¦£°£¿ù¡AÁÂÁÂ~
½Ð±Ð§ï¨}³t«×¤èªk
½ÐÀ°¦£Â½Ä¶¤@¤Uµ{¦¡
Àx¦s®æ¥X²{®æ¦¡¬°¤å¦r©Î¶}ÀY¬°³æ¤Þ¸¹ªº¿ù»~
vlookup¦X¦}ªº¸ê®Æ
¦p¦ó¥i¥HÅý¤£¬O"JPM"¤£Åã¥Ü¥X¨Ó¡A¤]¤£·|¯d¤@
¦¬ÂÃ
¤À¨É
198188
µoµu®ø®§
¥[¬°¦n¤Í
198188
·í«eÂ÷½u
UID
11471
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ª÷¿ú
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
290 ¤p®É
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
°ª¤¤¥Í
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
2
#
µoªí©ó 2012-12-6 22:43
|
¥u¬Ý¸Ó§@ªÌ
½Ð°Ý¦³µL°ª¤H¥i¥HÀ°¦£¡C·í«eªºexcel VLOOKUP ¥t¤@Óexcel¡A³oÂI§Úª¾¹D¡A¦ý¬Û¤Ï¡A¥Î¥t¤@Óexcel¨Óvlookup ·í«eªºexcel §Ú´NøÃÑ¡C¦]¬°øª¾¹DÀ³¸Ó¦p¦ó¥Îwith worksheets¤§Ãþ
TOP
198188
µoµu®ø®§
¥[¬°¦n¤Í
198188
·í«eÂ÷½u
UID
11471
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ª÷¿ú
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
290 ¤p®É
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
°ª¤¤¥Í
©«¤l
430
¥DÃD
65
ºëµØ
0
¿n¤À
521
ÂI¦W
30
§@·~¨t²Î
win7
³nÅ骩¥»
office 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2012-10-30
³Ì«áµn¿ý
2024-8-13
3
#
µoªí©ó 2012-12-7 12:39
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
198188
¤U¸ü
(44.1 KB)
payment report
2012-12-7 12:38
¤U¸ü
(53.23 KB)
outstanding
2012-12-7 12:38
½Ð°Ý¥i§_¦boutstanding payment¤ºvlookup payment report ¡Aµ{¦¡©ñ¦boutstanding payment¤º
¦pªGpayment report HÄæ¹F¨ì95%©Î¥H¤W¤ÎKÄ檺¤é´Á¬O·í¤éªºSO#¡A¦Ó¦boutstanding payment ¨S¦³³oÓSO#(order AÄæ¡^¡A´N§âpayment report ªºSO#copy¦boutstanding payment AÄæ(ORDER)ªº³Ì«á¤@µ§¸ê®Æ¤§¤U¡C(¨âÓexcelªº¸ê®Æ·|¤£°±ªº¼W¥[¸ê®Æ¡A©Ò¥H¨S¦³©T©wªº¤@¦C¬O³Ì«á¤@µ§¸ê®Æ¡^
TOP
ÀR«ä¦Û¦b :
Ä@n¤j¡B§Ón°í¡B®ðn¬X¡B¤ßn²Ó¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·