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

[µo°Ý] ¤£¦Psheet¶¡Äæ¦ìªºÂà´«

[µo°Ý] ¤£¦Psheet¶¡Äæ¦ìªºÂà´«

¨Ò¦p
sheet 1ªº¤é´Á¬° B1,C1,D1
·Q­nª½±µµ¥©ósheet2 ªº A2,A3,A4
·í§Ú¿é¤J¦bsheet2ªºA2¬° "=Sheet1!C1"
µM«á©¹¤U©Ô®æ¦¡,µ²ªGA3Åܦ¨ "=Sheet1!C2"
©Ò¥H§Ú§ïA3¬° "=Sheet1!C$1"
¦ý¥LªºC¤£·|Åܦ¨D,¥i¥H½Ð±Ð¦³Ô£¿ìªk¨Ï¨ä§ïÅܶÜ,3Q
ªþ¤W¹Ï¤ù¥H¨Ñ°Ñ¦Ò

sheet2!A2=OFFSET(Sheet1!$B$1,,ROW(A2))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


·PÁ¶W¯Åª©¥D!!
«ü¥O¤£¬O«Ü©ú¥Õ
¤£¹Lµy·L§ï¤@¤U¤º®eA2¤~¥¿½T¥X²{¸ê®Æ

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD