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

[µo°Ý] Ū¨úÀÉ®×°ÝÃD

[µo°Ý] Ū¨úÀÉ®×°ÝÃD

§Ú·Q­n°Ý»¡
²{¦b§Ú¦³2­Óworkbooks,  Workbook("A")»P Workbook("B")
Workbook("B")¸Ì ¦³10­Óworksheets,  10­Óworksheetªº¦WºÙ¼ÐÅÒ¬°1,2,3,4,5,6,7,8,9,10

¨Ì¾ÚWorkbook("A")ªº¼Æ­È ,   ¥hworkbook("B")´M§ä¹ïÀ³ªº¦WºÙªºworksheet ,   ¦A§âµ²ªG¿é¥X¦Ü·sªºWorkbook
(¿é¥X¦Ü·sworkbookªº¼Æ­È=Workbook("A")ªº¼Æ­È+workbook("B")©Ò§k¦Xªºworksheet¸Ìªº¼Æ­È)

workbooks("C").sheets(1).range("A1").value = workbook("A").sheets(1).range("A1").value + workbook("B").sheets( workbooks("A").sheets(1).range("C1").value).range("B1") .value

§â  WORKBOOK A , SHEETS 1 ¤WA1ªº­È,
¥[¤WWORKBOOK A, SHEETS 1 ¤WC1 «ü¥ÜªºWORKBOOK B­¶¼Æ¤U B1 ªº¼Æ­È®³¨ì   
WORKBOOK C¤W SHEET 1ªºA1¦ì¸m
¥i¥Hµo­Ó¹ê»Ú¨Ò¤l¶Ü? ¤£µM¬Ý§¹¤W­±¤@¥y¤]¤£ª¾¬O¤°»ò
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

§Ú¤w¸gªþ¤W¤p¨Ò¤l
Excel.rar (32.27 KB)

´N¬O§Ú·Q±qAÀÉ®× .¤u§@ªí¤@ ªºCÄ檺­È, ¥h§äBÀɮײŦXªº¤u§@ªí¦WºÙ,
µM«áAÀÉ®×CÄæ­È»PBÀɮײŦXªº¤u§@ªí­È¬Û¥[,
µ²ªG·Q­n¿é¥X¦ÜAÀɮתº·s¤u§@ªí¸Ì

·PÁ±zªº¦^ÂÐ

TOP

§Ú¤w¸gªþ¤W¤p¨Ò¤l


´N¬O§Ú·Q±qAÀÉ®× .¤u§@ªí¤@ ªºCÄ檺­È, ¥h§äBÀɮײŦXªº¤u§@ªí¦WºÙ,
µM«áAÀÉ®×CÄæ­È ...
Helain µoªí©ó 2011-10-25 11:31



·s¤u§@ªíªºµ²·|¤£·|¬O¸ò¤U¹Ï¿ï¤Wªº¤@¼Ë?
twbts20111027indirect.jpg
2011-10-27 00:19

¬Ý§Aªº¥N½X,¥Í¦¨ªº·|¬O³Ì¦h10­Ó¤u§@ªí,¤£¬O¤@­Ó...

¨ä¹ê¦pªG·Q±o¦p¤W¹Ïªºµ²ªG,¥Î¤@¤UINDIRECT´N¥i¥H¤F
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD