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

[µo°Ý] ½Ð°Ý¦³¤½¦¡¥i¥H¸ó¤u§@ªí¿ï¨ú¨ä¥L¤u§@ªí¸ê®Æ¶Ü?

[µo°Ý] ½Ð°Ý¦³¤½¦¡¥i¥H¸ó¤u§@ªí¿ï¨ú¨ä¥L¤u§@ªí¸ê®Æ¶Ü?

ª©¥D¦n
²{¦b¦³­Ó¸ê®Æªí
¦b¤u§@ªí1(ªí³æ)
¥ÎVLOOKUP¥i¸Ñ¨M¥Î¤½¥q¦W±a¥X¦í§}¤Î¹q¸Ü
¦ý¬O¶·¦b¦P¤@¤u§@ªí­¶­±
½Ð°Ý
­Y¯à¦b¸ê®Æªí¤¤ª½±µ²Ö­p¿é¤J»Ý­nªº¸ê®Æ
¦Ó¤£¦A¤u§@ªí(ªí³æ)¤¤«ùÄò¿é¤J
½Ð°Ý¦³¨ä¥Lªº SHEET1.rar (3.95 KB) ¤½¦¡©Î¤èªk¶Ü?
ÁÂÁÂ!!

ÁÂÁ¤j¤jªº«ü±Ð

TOP

³o­Ó¤½¦¡¹ï§Ú¨Ó»¡,«Ü¾A¦X¥Î¦b¤u§@¤W...
joyce

TOP

¦^´_ 14# Hsieh


    ª©¥D
±z¤ÓÁ¾µê¤F...

½×¾Â¬O¤j®aªº¶é¦a
­n¤j®a¤@°_Äéµ@¤~·|­_§§ªø¤[

¤£­n»´©¿¤F©Ò¦³¤Hªº¯à¤O
¥ô¦ó¤H¥u­n¦³¤ß³£¯à°µ¨ìªº(³o¥y¸Ü¹ï§Ú­Ì³oºØ¤ô¥­ªº¤H­nªá«Ü¤jªº¤ß¤O¤~¯à¹F¨ì)

Á٧Ʊæ¥S¥x¤]¯à¬°½×¾ÂºÉ¤@¥÷¤ß¤O(¯à¤O¦³­­..¦ý¬OºÉ¤O¦Ó¬°..À³¸Ó»¡¶q¤O¦Ó¬°)
ÁÂÁÂ!
¥t¥~¤]·PÁª©¥D­Ì¨¯­WªºÄéµ@...¦]¬°µo²{§A­Ìªº¦^¤å®É¶¡¤j³¡¤À³£¦b±ß¤W©Î¥b©]
¬Û«H¥Õ¤Ñ³£ÁÙ¦³¦b¤u§@
©Ò¥H¤j®a¨¯­W..¥[ªoÅo!!...­É¥Î¶{ª©¥D»¡ªº¤@¥y¸Ü:¦@«j¤§!~~

TOP

¦^´_ 13# PD961A


    ¨ä¥L¤H¤j·§³£·Qª½±µ¥á°ÝÃD¤W¨Ó½Ðª©¥D¸Ñ´N¦n¤F
³o¥y¸Ü§Ú­n´£¿ô¦U¦ì
ª©¥D¨Ã«Dµ´¹ï³£¯à¸Ñ¨M°ÝÃD
ª©¥D¨Ã«D¬OÀ°¦£¸ÑÃDªº
ª©¥D¥u¬O­Ó¦WºÙ¬OÀ°¦£³B²zª©°È
½×¾Â¬O¤j®aªº¶é¦a
­n¤j®a¤@°_Äéµ@¤~·|­_§§ªø¤[
©Ò¥H¨Ó¦¹´N¬O­n¾Ç²ß§Þ¥©
§A»¡«Ü¦h¨ç¼Æ¬Oª©¥D¦Û³Ð
¨ä¹ê¨º³£¬O°ò¥»¨ç¼Æªº²V¦XÀ³¥Î
¥ô¦ó¤H¥u­n¦³¤ß³£¯à°µ¨ìªº
¤£­n»´©¿¤F©Ò¦³¤Hªº¯à¤O
Á٧Ʊæ¥S¥x¤]¯à¬°½×¾ÂºÉ¤@¥÷¤ß¤O
ÁÂÁÂ!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 12# Hsieh


    ª©¥D
±z»¡ªº¬O¨S¿ù
EXCEL¥»¨­¤½¦¡´N«Ü±j¤j
¦ý¬O®Ñ¥»¤Wªº¤º®e³£¬O¤j·§´£¤@¤U
°£«D¥¿¦¡¤W¹L½Ò(ÁÙ­nÅ¥ªºÀ´)§_«h¿ú³£¬O¥Õªá
©Î¬O¦³¨ì¨t²Î³Â»¶¥h..¥h·j´M¤j·§¬Ûªñªºµ{¦¡¤º®e
µM«á¦A®M¶i»Ý¨Dªº³¡¥÷
¥i¬O³o¬O°w¹ï¦³¤@©w°ò¦ªº¤H¤~¦³¥i¯à°µ±o¨ìªº
¨ä¥L¤H¤j·§³£·Qª½±µ¥á°ÝÃD¤W¨Ó½Ðª©¥D¸Ñ´N¦n¤F...
¦Ó¥B¨t²Î¸Ì­±¦³¥h¬Ý¹Lªº¤H´N·|ª¾¹D..«Ü¦hEXCEL¤½¦¡¬Oª©¥D¦Û³Ðªº(®Ñ¥»ùجO¨S¦³ªº)
¦Ó¤£¬O½Ò¥»¤W©Î¬O¥ú¬ÝEXCEL°ò¦½g´N¯à¿Ä·|³e³q..
©Ò¥Hª©¥D¤]½Ð¤£­n¤Ó­V¨D§Ú­Ì¯à¹F¨ì±z¤@¥bªº¤ô·Ç
²¦³º¯à¥ÎEXCELªº¤½¦¡´N¸Ñ¨Mªº
´N¹³±z»¡ªº¦ó¥²¥ÎVB....
ÁÂÁÂ!

TOP

¦^´_ 11# PD961A


    ¦Ñ¤FÁÙ¥i·R¨º¯uªº¤£¿ù
°ÝÃDªº¸Ñ¨M¤èªk©¹©¹¤£¥u¤@ºØ
§Ú­Ì¦Û¤v¤£ª¾¹Dªº¤£¥Nªí´N¨S¦³
EXCEL¥»¨­´N¦³¨Ç¥ý¤Ñ­­¨î³o´N¬O³W«h
´N¹³ÅçÃÒ¨Ó·½­n¸óªí¨Ï¥Î´N­n¥Î©w¸q¦WºÙ
³o¬O¥Lªº­­¨î
§A´N­n¿í¦u§_«h¥L´N¿ùµ¹§A¬Ý
·íµM§A·|VBA¤]¥i¥H¥ÎVBA¸Ñ¨M
¦ý¤@¯ë¨Ó»¡
°ò¥»¾Þ§@¯à°µ´N¥Î°ò¥»¾Þ§@
OFFICE¥»¨­ªº¥\¯à¤w¸g«Ü±j¤j¤F
ªá¿ú¶R¨Óªº¥\¯à©ñµÛ¤£¥Î¨º°Z¤£Á«¤j¤F
¦A¨Ó¬O¨Ï¥Î¤½¦¡¨Ó¹F¨ì­n¨D
¦]¬°³o¨Ç¨ç¼Æ¤]¬O¿ú¶Rªº
¦A¨Ó¦Ò¼{¥ÎVBA
¦]¬°§Aªºµ{¦¡²¦³º¤]¬O¦b°µ³o¦P¼Ëªº¨Æ±¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 10# Hsieh


    ªO¥D
±z¤Ó¥i·R¤F§a!!!
¨º´N¦^¨ì§Ú°Ýªº­ìÂI°Õ!
¸ó¤u§@ªí¤~·|¥Î¨ì©w¸q¦WºÙ
¬JµM¤£¸ó¤u§@ªí
·íµM¬Oª½±µ¼g´NOK°Õ!
¥u¬O³æ¤@¤u§@ªí­Y­n¦h¨ä¥LªF¦è
´N·|Åܪº«Ü­â¶Ã
©Ò¥H¤~·|
·Q
¦pªG¥i¥H¤À¦h­Ó¤u§@ªí..¦ý¬O¥i¥H¶×¾ã¨ì¤@±i¤u§@ªí§Y¥i....

¦ý¬O¥i¯à·|Åܱo½ÆÂø¦h¤F
¤]³\¨ì³Ì«á°®¯Ü¼gVB¤ñ¸û§Ö!!!

ÁÂÁª©¥D!

TOP

¤£¸ó¤u§@ªíª½±µ¼g¤½¦¡¶i¥h´N¦æ°Õ!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh


    ªO¥D
    ¥»¨ÓÂI¶i¥h°Ï¶ô´N·|°{Ã{³]©wªº½d³ò­Èªü!
±z³]ªº©w¸q¬O¨S¿ùªº
¥u¬O­è­è¨º«Êµo¤å
¬O­n¸Õ¸Õ¦³¨S¦³§Oªº¤è¦¡©Î¤½¦¡
¥i¥H¦b¦P­¶­±¨Ï¥Î
¦Ó¤£¥Î¸ó¤u§@ªí¥Î©w¸q¦WºÙ¥h·j´M

ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD