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

[µo°Ý] ½Ð°Ý¦p¦ó±N¤½¦¡°Ñ·ÓªºÄæ¦ì®æ¦¡¡A·Ó¶¶§Ç©¹¤U½s?

[µo°Ý] ½Ð°Ý¦p¦ó±N¤½¦¡°Ñ·ÓªºÄæ¦ì®æ¦¡¡A·Ó¶¶§Ç©¹¤U½s?

²³æÁ¿§Ú§Æ±æ¦p¤U¤è¦¡§e²{
Sheet1ªºC2Äæ¦ì¡A¤½¦¡¬°=Sheet2!A3
Sheet1ªºC9Äæ¦ì¡A¤½¦¡¬°=Sheet2!A4
Sheet1ªºC16Äæ¦ì¡A¤½¦¡¬°=Sheet2!A5
Sheet1ªºC23Äæ¦ì¡A¤½¦¡¬°=Sheet2!A6
¡C
¡C
¦pªG¬O³æ½Æ»sSheet1ªºC2Äæ¦ì¡A¶K¨ìSheet1ªºC9Äæ¦ì¡A¤½¦¡·|Åܦ¨=Sheet2!A10¡A
¦³¿ìªk¦p¤W­±ªº¼Ë¤l§e²{¶Ü¡A³Â·Ð¦U¦ì«e½ú¤F¡AÁÂÁÂ!!

=INDIRECT("A"& INT(ROW()/7)+3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«D±`·PÁª©¥DªºÀ°¦£¡A¥i¥¿±`¨Ï¥Î!!

TOP

¦^´_ 2# ML089


½Ð°Ý¤@¤U¿ß«}¤j¡G¡@³o»yªk¬O§_¤£¯à¥Î¦b  Excel 2003 ?
§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¦^´_ 1# WOW9637
   
¦pªG¬O³æ½Æ»sSheet1ªºC2Äæ¦ì¡A¶K¨ìSheet1ªºC9Äæ¦ì¡A¤½¦¡·|Åܦ¨=Sheet2!A10¡A
Sheet1ªºC2Äæ¦ì¡A¤½¦¡¬°=Sheet2!A3 ¬O¬Û¹ï¦ì¸m
¤½¦¡§ï¬°=Sheet2!$A$3 µ´¹ï¦ì¸m
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# »k¥ú°j¯T

INDIRECT ¬O EXCEL 2003 °ò¥»«ü¥O¡A§@¥Î»POFFSET¬Û¦P
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD