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

[µo°Ý] ¹ïÀ³xlsÀɪº­È¡A¬O§_¦³¿ìªk¦Û¥ÑÅܧó

[µo°Ý] ¹ïÀ³xlsÀɪº­È¡A¬O§_¦³¿ìªk¦Û¥ÑÅܧó

Book1.zip (213.23 KB)
RT

¦pªG¬O  ¤u§@ªí¤º
¥Î¨ú¥N  ¦p  BOOK1¨ú¥N¬°  ABCDE


¦pªG¬Oµ{¦¡½X¤º
¥Î¤@­Ó¥N¼Æ¤U¥h¥N
¦p QDD = [A1]   '(A1§Y¬°­n§ïªº­È
=[QDD]Sheet1!A$1

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¤£¦n·N«äªí¹F¤W¥i¯àÅý¤H»~¸Ñ¤F¡C
¦pªG¦³¤T­ÓxlsÀÉ¡G
1¡BBook1.xls
2¡B·s¸ê®Æ§¨.xls
3¡BABCDE.xls

Book1.xls
B1=[·s¸ê®Æ§¨.xls]Sheet1'!A$1 (§Ú¥Î¤â°Ê¤è¦¡³sµ²¸ê®Æ)

¦pªG·Q¦bBook1.xls A1¿é¤J¥ô¦ó¼Æ­È¡õ
A1=ABCDE
B1=[ABCDE.xls]Sheet1'!A$1(¨Ì·ÓA1¿é¤J¼Æ­È«áB1³sµ²xlsÀɦW·|¦Û°ÊÅܧó)
        (¦Û°ÊÅܧó³B)
RT

TOP

¦^´_ 3# tzungshiun

B1=INDIRECT("[" &A1&"]"&"Sheet1!A$1")

TOP

«D±`·PÁÂ¥¿¬O§Ú­nªº¤è¦¡¡A¦ý¬O¦A½Ð±Ð¤@¤U¡A
Book1.xlsÀÉ®×Ãö³¬«á¦A¥´¶}¤½¦¡³£·|Åܦ¨¡F
#REF¡I¤£ª¾§Ú¬O§_¦³º|¤F¤°»ò­«­nªº¨BÆJ¡A
¦A½Ð½ç±Ð~ÁÂÁ¡I¡I
RT

TOP

¦^´_ 5# tzungshiun

±ý³sµ²¤§excelÀÉ®×(·s¸ê®Æ§¨.xls ABCDE.xls)
¶·¶}±Ò

TOP

¤F¸Ñ¡I¦A¦¸·PÁ§Aªº¸Ñ´b~ÁÂÁ¡I
RT

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD