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

[µo°Ý] ¤£¦PSHEET ¾î¦V©ì¦²¦³³W«ß¶¡®æªº¤½¦¡

[µo°Ý] ¤£¦PSHEET ¾î¦V©ì¦²¦³³W«ß¶¡®æªº¤½¦¡

¦U¦ì°ª¤â¦n¡G

¤p§Ì¦bSheet1¦³¸ê®Æ(¾î¦V¤@ª½¨ìNJÄæ¦ì)

¦ÓSheet2³øªí­n§ì¨úSheet1ªº¸ê®Æ¡A¦ý¬O¸ê®Æ¬O¦³³W«ßªº¶¡®æ

¦p¡G

sheet2ªºA1¤º®e¬°¡i='Sheet1'!A1¡j
sheet2ªºB1¤º®e¬°¡i='Sheet1'!D1¡j
sheet2ªºC1¤º®e¬°¡i='Sheet1'!H1¡j
©T©w¸õ¤T®æ¦ì¡C

½Ð±Ð¦U¦ì°ª¤â¤½¦¡¸Ó¦p¦ó©Ô©O¡H

§ä¨ì¸Ñ¨M¤èªk¤F

ÁÂÁ¡C

=OFFSET(Sheet1!$A$1,,COLUMN(A1)*2-2)

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD