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

½Ð°Ý¦V¤U¶ñº¡ªº°ÝÃD

½Ð°Ý¦V¤U¶ñº¡ªº°ÝÃD

½Ð°Ý¦V¤U¶ñº¡ªº°ÝÃD
½Ð°Ý§Ú¦bsheet2ªºAÄæ¦ì­n¤U©Ô¤½¦¡
¦p¦ó1¹ï1Äæ¦ì¤U©Ô¤U¨Ó©O¡H
¨Ò¦p
¦bsheet2¤¤ ¤½¦¡ª½±µ¤U©ÔÅã¥Ü
a2=INDIRECT("sheet1!a2")
a3=INDIRECT("sheet1!a3")
a4=INDIRECT("sheet1!a4")
ÁÂÁÂ

Book1.rar (9.36 KB)

Tony

¦^´_ 1# tonycho33

A2=INDIRECT("Sheet1!A"&ROW())
©Î
A2=Sheet1!A2

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD