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

[µo°Ý] ¸ó¤u§@ªí°Ñ·Ó¤å¦r

[µo°Ý] ¸ó¤u§@ªí°Ñ·Ó¤å¦r

½Ð°Ý°ª¤â
¸ó¤u§@ªí°Ñ·Ó³]©w°ÝÃD

§Ú·Q±Nsheet1 A1¸Ìªº¤å¦r³]©w¸òsheet2 A1ªº¤å¦r¬Û¦P
­Y¶}±Ò¤@­Ó·sªº¤u§@ªí³£¨S¦³°ÝÃD
¦ý¬O¥Ø«e¨Ï¥ÎªºexcelÀÉ ¬O¥Ñ¦P¨Æµo¹L¨Óªº
§Ú±N¦P¨Æµo¹L¨ÓªºÀɮפ¤sheet1 A1 ¿é¤J"=sheet2!A1"
Sheet2 A1 ¤º®e¬°­^¤å¦r "smart"
¬°¤°»òsheet1 A1«oÅã¥Ü¬°"0"
µLªkÅã¥Ü¤å¦r"smart"©O

ÁÂÁÂ
~~

¤]¥i¥H¥Î
indirect ¤Þ¥Î
¦pªG¥X²{¼Æ­È
¥[¤J""§Y¥i

TOP

¦^´_ 10# ANGELA


­ì¨Ó¦p¦¹,
ÁÂÁ´X¦ì«e½úªº«ü¾É
~~

TOP

¥»©«³Ì«á¥Ñ chiahuo ©ó 2011-1-18 16:06 ½s¿è

¦^´_ 9# guinevere
¤p§Ì¤@¶}©l¡A¬O¤@­Ó¤@­Ó¡A¥h¸Õµ²ªG¥u¦³A3¦³­È¡A¨ä¥Lªº¬°0

µª®×´N¹³¼Ó¤W»¡ªº¡A¥u¦³A3¦³­È¡A¨ä¥L´N¬O0

Ãö©ó©w¸q¦WºÙ¡A½Ð°Ñ¾\
http://forum.twbts.com/thread-1405-1-1.html
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦^´_ 9# guinevere


    ='MCP for TC17'!A3:H3  §ì¨ìªº¬O°}¦C  {"Smart",0,0,0,0,0,0,0}   ¦]¬°A3¨ìH3¬O¦X¨Ö®æ¥u¦³A3¦³­È

    ¤½¦¡¦bBÄæ©Ò¥H§ì¨ì°}¦C²Ä¤G­Ó­È0,¦pªG¤½¦¡¦b²ÄAÄæ´N¥i¥H¦¨¥ß

   ='MCP for TC17'!A3      °w¹ïA3

TOP

¦^´_ 8# chiahuo


½Ð°Ý
³o¨âºØ»yªk
¦³¬Æ»ò¼Ëªº®t§O?
ÁÂÁÂ
~~

TOP

¦^´_ 6# guinevere



½Ð»yªk±N§ï¬°MCP for TC17'!A3¡A´N¥i¥H¤F
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦^´_ 5# gong


gong¤j­ô

§ÚÁÙ¬O¤p¾Ç¥Í¼h¯Å
¤U¸ü¤£¤FÀÉ®×°Õ!!>_<
~~

TOP

¦^´_ 3# chiahuo

Àɮפ¤
§Ú·Q±NSheet "MAIN" ¤¤B7»PB13ªº¤º®e³]©w¦¨»P
Sheet "MCP for TC17" ¤¤ªºA3¬Û¦P(A3¨Ï¥Î¦X¨ÖÀx¦s®æ)
¥i¬O¦bSheet "MAIN" ¤¤B7»PB13¿é¤J"='MCP for TC17'!A3:H3"«á
B7¥X²{0
B13¥X²{='MCP for TC17'!A3:H3
½Ð°Ý¬O­þ¸Ì³]©w¦³°ÝÃD©O¡H

Quotation.zip (83.46 KB)
~~

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-1-14 11:27 ½s¿è

SHEET1!A1=0,®æ¦¡¦Û­q"SMART"
SHEET2!A1=SHEET1!A1,Åã¥Ü0

SHEET1!A3=SMART
SHEET2!A3=SHEET1!A3,®æ¦¡¦Û­q";;;"0"",Åã¥Ü0

Book1.rar (1.39 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD