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

[µo°Ý] ¨â­Óexcel¥H¤W¡A¬d¸ß¤èªk

[µo°Ý] ¨â­Óexcel¥H¤W¡A¬d¸ß¤èªk

½Ð°Ý§Ú¦³¨â­Óexcel(¥Ò©M¤A)

¥Ò¬O¥Î¨Ó·í¸ê®Æ®w¨Ï¥Î
¸Ì­±ªºaÄæ¨Æ¶µ¦¸¡Cex1-99

¤A¬O¥Î¨Ó¬d¸ßªº
ÂI¿ï¶µ¦¸1¥i¬d¸ß¨ì¥Òexcel¤ºªºa2-f2ªº¸ê®Æ

¥Ø«e¤p§Ìªºµ{¦¡½X¬O±N¥Òexcel¥´¶}¡A¥Î°j°éªº¤è¦¡·j´M
¦ý·í¸ê®Æ¶V¨Ó¶V¦hªº®É­Ô¡A³o¼Ë¦³ÂIºC....
ÁÙ¦³¬d¸ßªºexcel¼W¥[¨ì¤þ¡B¤B¡B¥³.....µ¥¡A³o¼Ë·|½Ä¬ð



½Ð°Ý¦³¤Hª¾¹D¤ñ¸û¦nªº¤èªk¶Ü??

ªþ¤Wªþ¥ó¡A·PÁÂ~~

swtseng.rar (24.74 KB)

TOP

¹ï¤F¡A§ÚÁÙ¦³¥Î¹LVLOOKUP¨ç¼Æª½±µ«ü©wÀɮ׸ô®|¤ÎÄæ¦ì

¦ýÀHµÛ¸ê®Æ®w¶V¨Ó¶V¤j¡A¬d¸ßªººØÃþ¤]¼W¦h
¥ÎVLOOKUP¨ç¼ÆÀÉ®×·|Åܱo«Ü¤j.....


½Ð°Ý¥i¥H¥ÎVBAµ{¦¡½X¤£¥Î¶}ÀɮסAª½±µ·j´M«ü©wªº¶Ü??

TOP

«ô°U.....¦³¤H¥i¥H¦^µª§Ú¶Ü??   

¬O¤£¬O§Ú°Ý±o¤ÓÅ¢²Î?

TOP

¦^´_ 1# swtseng
¥Ø«e¤p§Ìªºµ{¦¡½X¬O±N¥Òexcel¥´¶}¡A¥Î°j°éªº¤è¦¡·j´M
§A2#ªºªþÀɬO¨S¦³VBAªºÀÉ®×

TOP

¦^´_ 5# GBKEE


    ªþ¥ó¸Ì¦³¨â­Ó¤èªk
    ¤èªk¤@ªºµ{¦¡½XÀH¤âkey¡A©Ò¥HÅܼƨS«Å§i


¹ê»Ú¦b¨Ï¥Îªº±¡ªpÃþ¦ü¡A¦ýÀɮ׶q¶V¨Ó¶V¤j
¦³®É­Ô¤S¦³³sµ²®É¶¡¤Wªº°ÝÃD¡A¬Ý¯à¤£¯à¤£»Ý­n¶}ÀɮסA¥Îµ{¦¡½X³s½uŪ¨ú

swtseng.rar (29.65 KB)

TOP

¦^´_ 6# swtseng

°Ñ¼Æ¸ê®Æ®w¬d¸ß

    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¨ü±Ð¤F¡A§Ú¦b¸Õ¸Õ¬Ý¥i¤£¥i¥H¥Î¿ýªº¤è¦¡¡A¥Hµ{¦¡½X¨Ó§e²{

¦]¬°¸ô®|·|°µ§ó§ï.......

TOP

½Ð°ÝHsiehª©¥D¡A¥i¥H¥Îµ{¦¡½X¨Ó§e²{¶Ü??
§Ú¥Î¿ý»sªº¤è¦¡¡A¥X²{"°}¦C¯Á¤Þ¶W¥X½d³ò"¡AµLªk°õ¦æ..

TOP

¥i¥H¤F¡A­ì¥»¤w³s½uªº¸ê®Æ¤£¥i¥H§R°£
¥[¸ô®|©MÀɦWªºÅܼƫá´N¥i¥H¨Ï¥Î¤F

¥t¥~¡A³oºØ¤èªk¡AÀÉ®×´N1mb¥H¤W......
¤£ª¾¹D¦U¦ì°ª¤â­Ì¡A¦³¨S¦³¨ä¥Lªº¤èªk??

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD