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

§ä¨ì«ü©w¤u§@ªíªºÄæ¦ì

§ä¨ì«ü©w¤u§@ªíªºÄæ¦ì

½Ð±Ð­n¦p¦ó¼g¤½弍,§ä¨ì¤u§@ªí( ÅÜ¼Æ )ªº²Ä(ÅܼÆ)¦æ,»P(ÅܼÆ)¬Û¦PªºÄæ¦ì?
¬¡­¶Ã¯4.zip (9.43 KB)

=INDIRECT("'" & sht & "'!" & adr)

sht=¤u§@ªíÅܼÆ.
adr=Äæ¦ì¦ì¸mÅܼÆ.

Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

ÁÂÁÂ,¦ý§Ú¤£¤ÓÀ´,«ç»ò¹B¥Î¦bªþÀɪºEXCEL,¥i¥H¥Ü½d¦bªþÀÉexcel¶Ü?·PÁÂ!!

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

ÁöµM¤£¤ÓÀ´¤½¦¡ªº·N«ä,¦ý¦¨¥\¤F,¤Ó¼F®`¤F,«D±`·PÁÂ,

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD