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

WOW9637

²³æÁ¿§Ú§Æ±æ¦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ÁÂÁÂ!!

ML089

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

INDIRECT ¬O EXCEL 2003 °ò¥»«ü¥O¡A§@¥Î»POFFSET¬Û¦P

GBKEE

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

»k¥ú°j¯T

¦^´_ 2# ML089


½Ð°Ý¤@¤U¿ß«}¤j¡G¡@³o»yªk¬O§_¤£¯à¥Î¦b  Excel 2003 ?

WOW9637

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

ML089

=INDIRECT("A"& INT(ROW()/7)+3)