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

[µo°Ý] °Ýexcel...

[µo°Ý] °Ýexcel...

¤p§Ì¤S¹J¨ì¤@°ÝÃD

excel1Àɮצ³­û¤u²Õ§O(@a1)  
excel2Àɮצ³­û¤u²Õ§O¡B¦a§}¡B¹q¸Üµ¥

§Ú·Q«Yexcel1¬Ja3Àx¦s®æ¶}©llist«{a1¬J²Õ§O

¨Ò¦pa1¥´gp001
a3¥´¸¨´N·|list«{excel2Àɮפº©Ò¦³gp001­û¤u²Õ§O¡B¦a§}¡B¹q¸Ü

½Ð°ÝÀ³¸ÓÂI°µ¡HÁÂÁÂ:L

¦^´_ 1# kaiyin

     À³¸Ó¬O¥Îvlookup

    ¬O­»´äªºªB¤Í§a,½Ð¤W¶ÇexcelÀÉ,¨Ã¼ÒÀÀ»¡©ú»Ý¨D.

TOP

¬Ý°_¨Ó¥Î¶i¶¥¬d¸ß´N¥i¥Hº¡¨¬»Ý¨D¤F...
¨S¨Æ´N¨Ó³}³}

TOP

¬Ý°_¨Ó¥Î¶i¶¥¬d¸ß´N¥i¥Hº¡¨¬»Ý¨D¤F...
fr447446 µoªí©ó 2011-3-31 17:03



¯à§_±Ð¾É¶Ü????

TOP

¦^´_ 4# kaiyin


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

TOP

A.gif ·Pı³o­Ó¥Î¸ê®Æ®w¬d¸ß¸û¾A¦X

TOP

chin15¥Î Query ¡A¦³ÂIª±«Ü¤j¡C
¨S¿ù¡A¬O¥i¥H³o¼Ë¥Î¡A¤£¹L¦³ÂI¡Kª±«Ü¤j¡C
¦³ÂI¶}²´¬É¡C
¯uªº¬O­««×¨Ï¥ÎªÌ¡C
§Ú¤]¾ÇªÌÂI¡C

TOP

ª±«Ü¤j¶Ü¡H
¤£¦n·N«ä¡A§Ú¥u¬Oı±o¦¹¨Ò¨Ï¥ÎQuery¬d¸ß¸û¾A¦X
¥»¨Ó´N¬O°ò¦¥\¯à¡A¾Þ§@¤]²³æ¡A«Ø¥ß­Ó¬d¸ß¥Î¤£¨ì¤@¤ÀÄÁ
¦h¼Æ¤H³£·|°µªº
¶i¶¥¿z¿ï¤]¥i¥H¡A¤£¹L¶·¥ý©w¸q°ÊºA½d³ò
¦Ó¥B¬d¸ßªº¶µ¥Ø¤£¦P®É¤S­n­«·s¿z¿ï¤@¦¸

TOP

¥»©«³Ì«á¥Ñ kaiyin ©ó 2011-4-7 09:12 ½s¿è
¦^´_  kaiyin
Hsieh µoªí©ó 2011-4-1 10:48


¨C¦¸¥u¯à¥Î¤@¦¸¶Ü????
·í¿é¤J¥t¤@­Ó¼Æ­È´N¤£¯à¦Û°Ê§ó·s¤F...

TOP

·Pı³o­Ó¥Î¸ê®Æ®w¬d¸ß¸û¾A¦X
chin15 µoªí©ó 2011-4-1 13:36


·í¦b"¿ï¨ú¤u§@ï"®É¡A
¥X²{"¦¹¸ê®Æ¨Ó·½¤¤¨Ã¥¼¦s¦b¥i¨Ï¥Îªºªí®æ¡C"
¤£¯à¨Ï¥Î¡C

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD