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

Excel ³sµ²¤u§@ªí°ÝÃD

Excel ³sµ²¤u§@ªí°ÝÃD

¿Ë·Rªº¥ý¶i¡A§Ú¦³¤@¥÷ªí³æ
¦p¤U¹Ï



¦bDÄ檺¤½¦¡¬O ='W11-0312-0318'!C12
·Q½Ð°Ýªº¬O¡A¦pªG§Ú¦bA3Äæ¦ì¦³KEY¤J¤u§@ªí¦WºÙ¡A¬O§_¦³¬Æ»ò¤½¦¡¬O¥i¥HÂI¿ïA3Äæ¡A¦Ó¦Û¤v¥h§ä¤u§@ªíªºÄæ¦ì
¦Ó¤£¥Î¤@­Ó¤@­ÓÂI¤u§@ªí¶W³sµ²ªº¤è¦¡
ÁÂÁ¤j®a!

Excel_½Æ»s¤½¦¡-¤u§@ªí.rar (6.99 KB)
Just do it.

B3:
=HYPERLINK("#'"&A3&"'!a1","³sµ²")
¤U©Ô

TOP

¦^´_ 2# ­ã´£³¡ªL


±z¦n¡A§Ú·Q§Ú»¡ªº¤£²M·¡
§Úªº·N«ä¬O«ü»¡¡A
D3 ¤½¦¡='W11-0312-0318'!C12

¬O§_¥i¥H¦³¯S®íªº¨ç¼Æ¥i¥H§ï¦¨¬°='A3'!C12
¥¦·|¦Û°Ê¥h¤u§@ªíW11-0312-0318ªºC12Äæ¦ì¤U
Just do it.

TOP

¦^´_ 3# jsc0518


=INDIRECT("'"&A3&"'!C12") ¤U©Ô

TOP

¦^´_ 4# ­ã´£³¡ªL

ÁÂÁ§Aªº«ü¾É¡A¥i¥H¥Î¡C
ª¾¹D¦p¦ó¦ê³s¤F
Just do it.

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD