ªð¦^¦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

ÁÂÁÂ
~~

¹J¨ì³oºØ±¡§Î, §Ú³£¬O¦A¶}¥t¤@­Ó·sÀÉ, µM«á±N¹ï¤èªº¸ê®Æ½Æ»s¹L¨Ó¶K¤W«á¦b·sªºÀɳoÃä¥h¤U¤½¦¡.

TOP

¤W¶ÇÀɮסA¥H§Q±Æ°£°ÝÃD
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

½T©wSheet2 A1 ¤º®e¬°­^¤å¦r "smart¡A­Y¬O´N¥t¦³¥È¾÷¡C

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

¦^´_ 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

¦^´_ 5# gong


gong¤j­ô

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

TOP

¦^´_ 6# guinevere



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

TOP

¦^´_ 8# chiahuo


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

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

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD