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

¦p¦ó¸ó¤u§@ªí³]©wÅçÃÒ¥\¯à¡H

¦p¦ó¸ó¤u§@ªí³]©wÅçÃÒ¥\¯à¡H

¥»©«³Ì«á¥Ñ peter460191 ©ó 2011-9-8 15:28 ½s¿è

A¤u§@ªí                                                    B¤u§@ªí

A.jpg B.jpg



½Ð°Ý¥ý¶i¡A±ý¦bA¤u§@ªí¤¤ªºA2¤ÎA3Àx¦s®æ¤¤¡A¸óB¤u§@ªí³]©w½d³ò(Àx¦s®æA2~A5)ªºÅçÃÒ¡A­n¦p¦ó³]©w¡A½Ð¤j®aÀ°À°¦£¡AÁÂÁÂ!
peter460191

©w¸q¦WºÙ.AA=sheet2!a2:a5
Åçµý²M³æ=AA

TOP

¦^´_ 2# ANGELA


    ·PÁÂANGELA ª©¥D¡A¸Õ¹L¤w¦¨¥\¤F¡A«D±`·PÁ¤S¾Ç¤F¤@©Û¡C
peter460191

TOP

¦pªGªO¤jªº¸ê®Æ¬O¤@ª½¼W¥[ªº¸Ü¡A«Øij¨Ï¥Î°ÊºA½d³òªº¨ç¼Æ
¦WºÙ©w¸q:SS
=INDIRECT("Sheet1!A2:A"&COUNTA(Sheet1!$A:$A))
°Ñ¦Ò¥Î~¯àÅý²M³æ§ó¨ã¾ã¼ä

TOP

¦^´_ 4# man65boy


    «D±`ÁÂÁÂman65boy
¤S¾Ç¨ì¤@©Û¡A¥t¥~½Ð°Ý¤@¤U³o¼Ëªº°ÊºA½d³ò¦³¼Æ¶qªº­­¨î¶Ü¡H
¦]¤§«e¥Î²M³æ¿é¤J¤è¦¡¡A¦n¹³¦³¼Æ¶qªº­­¨î¡C
peter460191

TOP

¦^´_ 5# peter460191


    AÄæ¦V¤U65536Äæ¡AÀ³¸Ó°÷¥Î
(¦]¤§«e¥Î²M³æ¿é¤J¤è¦¡¡A¦n¹³¦³¼Æ¶qªº­­¨î¡C)¬O«ü¬Æ»ò?
¦pªG¹J¨ìÃø³B¡A¦b´£¥X¡C

TOP

¦^´_ 6# man65boy


   

§Úªº·N«ä¬O¦b,¸ê®Æ -> ÅçÃÒ -> ²M³æ -> ¨Ó·½ ,ª½±µ¿é¤J¤¤¤å©m¦W,¦n¹³¦³ªø«×­­¨î,¤j¬ù¿é¤J´X¤Q­Ó«á´NµLªk¦A¿é¤J¤F¡C
peter460191

TOP

¦^´_ 7# peter460191


    ¥i§â©Ò»ÝÁôÂéΤ½¶}¶ñ¤Jªº¸ê®Æ¡A³]¦b¨ä¥Lªºsheet¸Ì¡A§â¥¦·í¦¨¸ê®Æ®wÀ³¥Î¡A©Îµ§¼Æ¤Ö®É¡A¤]¥i¦b¦P¤@­Ósheet¸Ì¿é¤J¦b«ü©wªºÄæ¦ì¸Ì¡A¸ê®ÆÅçÃÒ¦³¶W¹L6..7µ§¡A«Øij©ñ¦bÄæ¦ì¤ñ¸û¦n§ó·s©Î·s¼W¡C

TOP

¦^´_ 8# man65boy


   ÁÂÁ man65boy ªº«ü¾É

¦pªG©ñ©ñ¦b¤u§@ªíªºÄæ¦ìùØ¡A¦³®É»Ý¹w¯d·s¼WªºªÅ¶¡¡A¦ý³o¼ËÅçÃÒ¥\¯à´N·|¦³ªÅ¥Õ¦C¡A½Ð±Ð¦³¤°»ò¤èªk¥i¥H§ïµ½¶Ü?ÁÂÁ±z!
peter460191

TOP

¦^´_ 9# peter460191


    ¨Ï¥Î¤W­±4¼Ó§Ú´£¨ìªº¦WºÙ©w¸q

¦pªGªO¤jªº¸ê®Æ¬O¤@ª½¼W¥[ªº¸Ü¡A«Øij¨Ï¥Î°ÊºA½d³òªº¨ç¼Æ
¦WºÙ©w¸q:SS
=INDIRECT("Sheet1!A2:A"&COUNTA(Sheet1!$A:$A))

¦p¦³¤£²M·¡ªº¡A¥i§âÀɮפW¶Ç¨Ó¬ã¨s¡C

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD