Ordinary

Æü¾ïÀ¸³è¤Îº³ºÙ¤Ê¤³¤È¤Ë¹¬¤»¤Î¼ï¤ò¸«¤Ä¤±¤Æ³Ú¤·¤ó¤Ç¤¤¤ëÊ¿Ëޤʥª¥ä¥¸¤Î»ëÅÀ

¥¿¥°¡§Excel

º£Æü¡¢Á´¤¯¶öÁ³¸«¤Ä¤±¤¿Excel¤Îµ»¡£
¤¿¤È¤¨¤ÐExcel¤Ë¤³¤ó¤Ê¥Ç¡¼¥¿¤¬¤¢¤ë¡£
CÎó¤Ë̾»ú¡¢DÎó¤Ë̾Á°¤òʬ¤±¤ÆÆþ¤ì¤¿¤¤¤È¤¹¤ë¡£
Ä̾ï¤Ê¤éLEFT´Ø¿ô¤¢¤¿¤ê¤ò»È¤Ã¤Æʬ¤±¤ë¤Î¤À¤¬¡¢
¤â¤Ã¤È»þû¤Êµ»¤¬¤¢¤Ã¤¿¡£
¥Õ¥é¥Ã¥·¥å¥Õ¥£¥ë01

C1¤À¤±¼«Ê¬¤ÇÆþÎϤ¹¤ë¡£¤½¤Î¤¢¤È¡¢Ctrl+E¡£
¤¹¤ë¤È¤¢¤Ã¤È¤¤¤¦´Ö¤Ë²¼¤Î¥»¥ëÁ´Éô¤Ë̾»ú¤¬¼è¤ê½Ð¤»¤ë¡£
¤³¤ó¤Ê´¶¤¸¡£
¥Õ¥é¥Ã¥·¥å¥Õ¥£¥ë02

D1¤âÁ´¤¯Æ±¤¸¤è¤¦¤Ë¤¹¤ë¤È¡¢¤¢¤Ã¤È¤¤¤¦´Ö¤Ë̾Á°¤À¤±¼è¤ê½Ð¤»¤ë¡£
¥Õ¥é¥Ã¥·¥å¥Õ¥£¥ë03

ˡ§À­¤òExcel¤¬¼«Æ°Ç§¼±¤·¤Æ¡¢¾¡¼ê¤ËËä¤á¤Æ¤¯¤ì¤ë¤È¤¤¤¦µ¡Ç½¤é¤·¤¤¡£
Word¤ÎÊʤǡ¢¥»¥ó¥¿¥ê¥ó¥°¤¹¤ë¤Ä¤â¤ê¤Ç¡¢Ctrl¡ÜE¤·¤¿¤é
¤È¤ó¤Ç¤â¤Ê¤¤¤³¤È¤¬µ¯¤­¤¿¤Î¤ÇÄ´¤Ù¤¿¤é¤³¤ó¤Êµ¡Ç½¤¬±£¤µ¤ì¤Æ¤¤¤¿¡£
²¿¤ÈExcel2013¤«¤é¤¢¤Ã¤¿¤é¤·¤¤¡£
ÃΤé¤Ê¤«¤Ã¤¿¤Ê¤¡¡£(;^_^A

¥¹¥Ú¡¼¥¹¥­¡¼¤Ç¸«¤¿ÌܤòÀ°¤¨¤ë¤Î¤Ï¤ä¤á¤Ê¤µ¤¤ ¡Á8³ä¤Î¼Ò²ñ¿Í¤¬¸«Íî¤È¤¹»ñÎÁºîÀ®¤Î¥­¥Û¥ó [ »Íã¹ ÀÅ»Ò ]
¥¹¥Ú¡¼¥¹¥­¡¼¤Ç¸«¤¿ÌܤòÀ°¤¨¤ë¤Î¤Ï¤ä¤á¤Ê¤µ¤¤ ¡Á8³ä¤Î¼Ò²ñ¿Í¤¬¸«Íî¤È¤¹»ñÎÁºîÀ®¤Î¥­¥Û¥ó [ »Íã¹ ÀÅ»Ò ]

¤¤¤Ä¤Î´Ö¤Ë¤«¡¢Âç³Ø¤ÎôÅö¥¯¥é¥¹¤ÎÊä½õ¶µºà¤Ë»ØÄꤵ¤ì¤Æ¤¤¤¿¡£
ºòǯ¤Þ¤Ç¤Ï¤¢¤Ã¤¿¤±¡ª¡©
±üÉÕ¤ò¸«¤¿¤é¡¢½ÐÈǤϺ£Ç¯¤Î½Õ¤À¤Ã¤¿¡£
Ä̤ê¤Çºòǯ¤Ê¤«¤Ã¤¿¤ï¤±¤À¡£

90¡ó¤ÏÃΤäƤ¤¤ë¤³¤È¤À¤Ã¤¿¤¬¡¢¤¢¤È¤Î10¡ó¤ÏÃΤé¤Ê¤¤¤³¤È¤À¤Ã¤¿¡£
Æɤó¤ÀËܤÇ10¡ó¤â»È¤¨¤ëÉôʬ¤¬¤¢¤ë¤Ê¤ó¤Æ¡¢Èó¾ï¤Ë¥³¥¹¥Ñ¤¬¤¤¤¤ËܤȸÀ¤¨¤ë¡£¡À(^o^)¡¿

°õºþ¤µ¤ì¤¿»æ¤Î½ñÎà¤Ï¸íËâ²½¤»¤ë¤¬¡¢Word¤Î¸µ¥Õ¥¡¥¤¥ë¤ò¸«¤ë¤È¡¢
¤®¤ç¤Ã¤È¤¹¤ë¤è¤¦¤Ê¥Õ¥¡¥¤¥ë¤¬¤¿¤Þ¤Ë¤¢¤ë¡£
PC¤Î¥×¥í¤òëð¤Ã¤Æ¤¤¤ë²ñ¼Ò¤¬¤³¤ó¤Ê½ñÎà¤òÇÛÉÛ¤·¤Æ¤¤¤ë¤«¤È»×¤¦¤È
¤³¤Á¤é¤ÎÊý¤¬ÃѤº¤«¤·¤¯¤Ê¤Ã¤¿¤â¤Î¤À¡£(;^_^A

¼«Ê¬¤¬¤½¤¦¤Ê¤é¤Ê¤¤¤¿¤á¤Ë¤â¡¢¤¤¤Ä¤Þ¤Ç¤âÊÙ¶¯¤Ï·ç¤«¤»¤Ê¤¤¡£

»ä¤¬½é¤á¤ÆPC¤ò»È¤¤»Ï¤á¤¿º£¤«¤é25ǯ¤Û¤ÉÁ°¡¢¤Þ¤À¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ê¤ó¤Æ¤â¤Î¤Ï¤Û¤È¤ó¤ÉÉáµÚ¤·¤Æ¤ª¤é¤º¡¢¤½¤ÎÂå¤ï¤ê¥Ñ¥½¥³¥óÄÌ¿®¤Ê¤ë¥Ð¡¼¥Á¥ã¥ëÀ¤³¦¤¬¤¢¤Ã¤¿¡£¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤È°ã¤Ã¤Æ¡¢ÌÀ³Î¤Ê´ÉÍý¼Ô¤¬¤¤¤¿¡£Î㤨¤Ð¡¢ÉÙ»ÎÄ̤¬¼çºÅ¤·¤¿Nifty-Serve¡£

¤½¤ÎÃæ¤ËÍÍ¡¹¤ÊÉô²°¤¬¤¢¤Ã¤Æ¡¢¤½¤³¤ÇÍÍ¡¹¤Ê¾ðÊó¸ò´¹¤¬¤µ¤ì¤¿¡£
º£¤ÎSNS¤ÈƱÍͤǤ¢¤ë¡£Í£°ì°Û¤Ê¤ë¤Î¤Ï¡¢º£¤Î¤è¤¦¤Ê¥Ö¥í¡¼¥É¥Ð¥ó¥É²óÀþ¤Ç¤Ï¤Ê¤¯¡¢ÅÅÏòóÀþ¤ò»ÈÍѤ·¤¿¤â¤Î¤Ê¤Î¤Ç¡¢Æ°²èÅù̵ÏÀ°ìÀڤʤ¯¡¢¤¹¤Ù¤Æʸ»ú¾ðÊó¤Î¤ß¡£

¤½¤ÎÃæ¤Ç»ä¤¬ºÇ¤â³Ú¤·¤ß¤À¤Ã¤¿¤Î¤Ï¡¢±Ñ¸ì¤Î²ñµÄ¼¼¤ÈPC¤Î²ñµÄ¼¼¤À¤Ã¤¿¡£
ÆäËÅö»þ¡¢Access¤Ç¥·¥¹¥Æ¥à³«È¯¤â¤É¤­¤ò¤·¤Æ¤¤¤¿¤³¤È¤â¤¢¤ê¡¢Access¤Î¥í¥°¤Ï¶ù¤«¤é¶ù¤Þ¤ÇÆɤߤޤ¯¤Ã¤¿¡£²áµî¥í¥°¤âÆɤó¤Ç¤â¤ï¤«¤é¤Ê¤¤»þ¤Ë¤Ï¡¢¼«Ê¬¤Ç¼ÁÌä¤â¤·¤¿¡£¤½¤¦¤¹¤ë¤È¡¢¤É¤³¤«¤Îã¿Í¤¬ÂçÂΤΤ³¤È¤Ï¤ï¤«¤ê¤ä¤¹¤¯ÀâÌÀ¤·¤Æ¤¯¤ì¤¿¡£¤·¤«¤â̵½þ¤Ç¡£

Excel¤ÎÉô²°¤Ë¤Ï°ì¿Í¡¢¶²¤í¤·¤¯²¿¤Ç¤âÃΤäƤ¤¤ë¿Í¤¬¤¤¤Æ¡¢Èà¤ÎÀâÌÀ¤òÆɤà¤È¡Ö¤Ê¤ë¤Û¤É¤Ê¡Á¡Á¡×¤È¡¢Ìܤ«¤éÎÚ¤¬²¿Ëç¤âÍî¤Á¤¿¤³¤È¤ò³Ð¤¨¤Æ¤¤¤ë¡£´Ø¿ô¤«¤éVBA¤ÎÏäޤǤ¹¤Ù¤Æ¤ÎʬÌî¤Ë¶²¤í¤·¤¤¤Û¤É¾Ü¤·¤¯¤Æ¡¢¤³¤Î¿Í¤Ï°ìÂΤɤó¤Ê¿Í¤Ê¤ó¤À¤í¤¦¡¢¤È»×¤Ã¤Æ¤¤¤¿¡£

¤ä¤¬¤Æ¡¢¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤ÎÇȤ¬¤ä¤Ã¤Æ¤­¤Æ¡¢¥Ñ¥½¥³¥óÄÌ¿®¤ÏÇȤˤΤޤì¤Æ¤¢¤Ã¤µ¤ê±À»¶Ì¸¾Ã¤·¤¿¡£¤¢¤Î²ñµÄ¼¼¤Î¥í¥°¤¬Æɤá¤Ê¤¯¤Ê¤ë¤³¤È¤¬¿¼¤¤Èᤷ¤ß¤À¤Ã¤¿¡£

¤È¤³¤í¤¬¡¢¤½¤Îã¿Í¤Ë½Ð²ñ¤Ã¤¿¡£¥Í¥Ã¥È¤ÎÀ¤³¦¤Ç¡£Youtube¤Ç¡£
¡ÖOffice TANAKA¡×
¡ÖÅÄÃæµü¡×¤µ¤ó¤È¤¤¤¦Ì¾Á°¤Ï²±¤¨¤Æ¤¤¤¿¡£
¤Þ¤µ¤«¤¢¤Îã¿Í¤ËYoutubeÆ°²è¤Ç½Ð²ñ¤¨¤ë¤È¤Ï¡£
¤·¤«¤â¥Ñ¥½¥³¥óÄÌ¿®¤Î¤³¤í¤è¤ê¡¢¤Ï¤ë¤«¤Ë¤ï¤«¤ê¤ä¤¹¤¤Æ°²è¤Î²òÀâ¡£¡Ê¾Ð¡Ë
¤³¤ó¤ÊÁÇÀ²¤é¤·¤¤²òÀ⤬̵ÎÁ¤Ç»ëÄ°¤Ç¤­¤ë»þÂ夬Íè¤ë¤Ê¤ó¤Æ¡£
¤¢¤¢¡¢ÁÇÀ²¤é¤·¤­ºÈ¡¢¤ï¤¬¿ÍÀ¸¡¡.Ž¡Žß+.(Ž¥¢ÏŽ¥)Žß+.Žß

º£Æü¤ÏÄ«¤«¤é¥¿¥¤¥Ô¥ó¥°¥Æ¥¹¥È¤Î·ë²Ì½¸·×¡£
55¥¯¥é¥¹Ê¬¤ò¤Þ¤È¤á¤ë¤Î¤Ç¡¢¤Ê¤«¤Ê¤«¹ü¤¬ÀÞ¤ì¤ë¡£
¤·¤«¤âº£²ó¤ÏÂç³Ø¦¤«¤é¥¯¥é¥¹Ã±°Ì¤Ç¤Ê¤¯
¸Ä¿Íñ°Ì¤Ç¤Î¥Ç¡¼¥¿¤âƱ»þ¤ËÍߤ·¤¤¡¢
»Ý¤ÎÏ¢Íí¤ò¼õ¤±¤Æ¤¤¤¿¤Î¤Ç°ìÁØÂçÊÑ¡£(^_^;)

1¥¯¥é¥¹1Ë示¤Ä¤Ë¤Þ¤È¤á¤é¤ì¤¿¥Ç¡¼¥¿¤ò
1Ëç¤Î¥·¡¼¥È¤Ë¹çÂΤµ¤»¤Ê¤¯¤Æ¤Ï¤Ê¤é¤Ê¤¤¡£
5¥¯¥é¥¹¤¯¤é¤¤¤Ê¤é¼êºî¶È¤Ç¤â¤Ç¤­¤ë¤¬
55¥¯¥é¥¹Ê¬¤ò¤Ò¤È¤Ä¤Ò¤È¤Ä¤ä¤Ã¤Æ¤¤¤¿¤é
¤µ¤¹¤¬¤Ë¥á¥²¥ë¡£(^_^;)

²¿¤«¤¤¤¤¥Þ¥¯¥í¤Ï¤Ê¤¤¤«Ãµ¤·¤¿¤é¡¢¤¢¤Ã¤¿¡£
¡ÖÊ£¿ô¤Î¥·¡¼¥È¤Î¥Ç¡¼¥¿¤òƱ¤¸¥¿¥¤¥È¥ë¤ÎÎó̾¤Ç¤Þ¤È¤á¤ëEXCEL¥Þ¥¯¥í¡×
¤É¤³¤«¤Î¸­¤¤Êý¤¬ºî¤Ã¤Æ¤¯¤À¤µ¤Ã¤¿¥Þ¥¯¥í¡£

»È¤¤Êý¤Ï¶Ë¤á¤Æ´Êñ¡£
¤Þ¤È¤á¤¿¤¤¥Ö¥Ã¥¯¤òͽ¤áµ¯Æ°¤·¤Æ¤ª¤¯¡£
¤½¤·¤Æ¾åµ­¥Þ¥¯¥í¤òµ¯Æ°¤·¡¢¡Ö¥·¡¼¥È·ë¹ç¤Î¼Â¹Ô¡×¥Ü¥¿¥ó¤ò²¡¤¹¡£
¤¹¤ë¤È³«¤¤¤Æ¤¤¤ë¥·¡¼¥È̾¤¬¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹Æâ¤Ë
ɽ¼¨¤µ¤ì¤ë¤Î¤Ç¡¢¤½¤ì¤ò¤Ò¤È¤Ä¤Ò¤È¤ÄÁªÂò¤·¤Æ¡¢¡ÖOK¡×¤ò²¡¤¹¡£
¤½¤ì¤À¤±¡£

55Ëç¤Î¥·¡¼¥È¤¬¤Û¤ó¤Î¿ôÉäÇ1Ëç¤ÎÆÈΩ¤·¤¿¥·¡¼¥È¤Ë½¸¤¦¡£
ĶÊØÍø¡ª¡ª
ºîÀ®¼Ô¤ÎÊý¤Ë¿´¤«¤é´¶¼Õ¤·¤¿¤¤¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£m(_ _)m

¤¢¤ë»¨»ï¤òÆɤó¤Ç¤¤¤¿¤é¡¢ÃΤé¤Ê¤¤Excelµ»¤òȯ¸«¤·¤¿¤Î¤Ç
¥·¥§¥¢¤·¤Þ¤¹¡£(^_^)

¤¿¤È¤¨¤Ð¡¢¤³¤ó¤Ê¤Õ¤¦¤ËϢ³¥Ç¡¼¥¿¤¬Æþ¤Ã¤Æ¤¤¤ë»þ
01

1¹Ô¤ª¤­¤Ë¶õÇò¹Ô¤òÆþ¤ì¤¿¤¤¤È¤¹¤ë¡£

ÉáÄ̤˹ÔÈÖ¹æ¤ò¥É¥é¥Ã¥°¤·¡¢±¦¥¯¥ê¥Ã¥¯¤ÇÁÞÆþ¤òÆþ¤ì¤ë¡£
02

¤¹¤ë¤È¡¢10¹ÔÌܤޤÇÁ´Éô¤¬¶õÇò¹Ô¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¦¡£
03


¤½¤³¤Ç¡¢10¹ÔÌܤޤǥɥé¥Ã¥°¤¹¤ë¤È¤­¤Ë
Ctl¤ò²¡¤·¤Ê¤¬¤é¡¢1¹Ô¤º¤Ä¥¯¥ê¥Ã¥¯¤¹¤ë¡£
04

¤è¤¯¸«¤ë¤ÈÈÏ°Ï»ØÄꤵ¤ì¤Æ¤¤¤ë¹Ô¤Î¾õÂÖ¤¬Èù̯¤Ë°Û¤Ê¤ë¡£

¤¹¤ë¤È¡¢1¹Ô¤º¤Ä¶õÇò¹Ô¤¬ÁÞÆþ¤µ¤ì¤ë¡£
05


¤³¤ó¤Êµ»ÃΤé¤Ê¤«¤Ã¤¿¤Ê¤¡¡£
ÀΤ«¤é¤Ç¤­¤¿¤Î¤À¤í¤¦¤«¡ª¡©
¤É¤Î¥Ð¡¼¥¸¥ç¥ó¤«¤é¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿¤ó¤À¤í¤¦¡ª¡©

1¹Ô¤º¤Ä¶õÇò¹Ô¤òÆþ¤ì¤ëµ¡²ñ¤Ï·ë¹½¤¢¤ë¤Î¤Ç
º£ÅÙÀ§È󤳤廤ò»È¤¤¤¿¤¤¡ª(^_^)

Excel¤Ï¥Û¥ó¥È¤Ë±ü¤¬¿¼¤¤¤ï¡À(¡ýo¡ý)¡¿¡ª

5
Excel¤Ç­¡¤ò¥ª¡¼¥È¥Õ¥£¥ë¤·¤Æ­¢¡¢­£¤È½Ð¤½¤¦¤È¤·¤Æ¤â¡¢
¿ô»ú¤Èǧ¼±¤µ¤ì¤Æ¤¤¤Ê¤¤¤¿¤á¡¢­¡¤¬¥³¥Ô¡¼¤µ¤ì¤ë¤À¤±¡£
¤³¤ó¤Ê¤Õ¤¦¤Ë¡£
¥ª¡¼¥È¥Õ¥£¥ë1


¤·¤«¤·¡¢¤Á¤ç¤Ã¤È¥¢¥¿¥Þ¤ò»È¤¦¤È¥ª¡¼¥È¥Õ¥£¥ë¤Ç¤­¤ë¡£
¤½¤Î¤¿¤á¤Ë¤Ï2¤Ä¤Î´Ø¿ô¤òÍí¤á¤ë¡£
1¡Ëcode´Ø¿ô¤Ç´ÝÉÕʸ»ú¤òʸ»ú¥³¡¼¥É¤ËÊÑ´¹¤¹¤ë¡£
¤¹¤Ù¤Æ¤Îʸ»ú¤Ë¤ÏÈֹ椬¿¶¤é¤ì¤Æ¤¤¤ë¤Î¤Ç¤½¤ì¤ò¸«¤Ä¤±¤ë
2¡Ë¤µ¤é¤Ë¤½¤ì¤Ë+1¤·¤Æ¼¡¤Îʸ»ú¤ò»ØÄꤹ¤ë¡£
3¡ËºÇ¸å¤Ëchar´Ø¿ô¤Çʸ»ú¥³¡¼¥É¤òµÕ¤Ëʸ»ú¤ËÊÑ´¹¤·¤Ê¤ª¤¹
¤³¤ó¤ÊÉ÷¤Ë¡£
¥ª¡¼¥È¥Õ¥£¥ë2


¤½¤Î·ë²Ì¤ò¥ª¡¼¥È¥Õ¥£¥ë¤¹¤ë¤È´ÝÉÕʸ»ú¤ò½Ð¤»¤ë¡£
¥ª¡¼¥È¥Õ¥£¥ë3
¤¿¤À¤·¡¢Ìµ¸Â¤Ë½Ð¤»¤ë¤ï¤±¤Ç¤Ï¤Ê¤¯¡¢ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë­´¤Þ¤Ç¡£(^_^;)

¤·¤«¤·¡¢¤³¤ì¤ò±þÍѤ¹¤ë¤È¡¢¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ä¥®¥ê¥·¥ãʸ»ú¤â
¥ª¡¼¥È¥Õ¥£¥ë¤Ç¤­¤ë¡£
¥ª¡¼¥È¥Õ¥£¥ë4


µ×¤·¤Ö¤ê¤ËPC»¨»ï¤ò¤á¤¯¤Ã¤Æ¤¤¤¿¤é¤³¤ó¤Êµ­»ö¤¬¤¢¤ê¡¢
´¶Æ°¤·¤¿¤Î¤ÇÁᮥ·¥§¥¢¤µ¤»¤Æ夭¤Þ¤·¤¿¡£
¿·Ç¯ºÇ½é¤ÎPC¹ÖºÂ¤È¤¤¤¦¤³¤È¤Ç¡£¡Ê¾Ð¡Ë

³ØÀ¸¤ËÄó½Ð¤·¤Æ¤â¤é¤Ã¤¿Excel¥Õ¥¡¥¤¥ë¤ò½¸·×¤¹¤ë¤è¤¦¤Ê»þ
¤¤¤Á¤¤¤Á¥Õ¥¡¥¤¥ë¤ò³«¤¤¤Æ¡¢³Îǧ¤¹¤ë¤Î¤ÏÌÌÅÝ¡£
¤½¤ÎºÝ¡¢°ì¤Ä¤Î¥Ö¥Ã¥¯¤Ë¥ï¡¼¥¯¥·¡¼¥È¤òÁ´Éô½¸¤á¤Æ¤·¤Þ¤¨¤Ð¡¢
¶ú»É¤··×»»¤ä¤éʬÀϤä¤é¿§¡¹¤È²Ã¹©¤¬Íưפ¯¤Ê¤ë¡£
¤½¤ó¤Ê»þ¤Ë»È¤¨¤ë¥Þ¥¯¥í¡£

¥Õ¥¡¥¤¥ë¤Ï¤¹¤Ù¤ÆƱ¤¸¥Õ¥©¥ë¥À¤ËÆþ¤ì¤Æ¤¯¤À¤µ¤¤¡£
½¸·×ÍѤΥ·¡¼¥È¤ò°ìËçºîÀ®¤·¤Æ¤ª¤­¡¢°Ê²¼¤Î¥Þ¥¯¥í¤ò¼Â¹Ô¡£
½¸·×ÍÑ¥·¡¼¥È¤Î¸å¤í¤Ë¤¹¤Ù¤Æ¤Î¥·¡¼¥È¤¬½¸¤Þ¤Ã¤Æ¤¯¤ì¤Þ¤¹¡£
½¸·×½ª¤ï¤ë¤È¡¢²¿¥³¤Î¥Ö¥Ã¥¯¤ò½¸¤á¤¿¤«¤â¥á¥Ã¥»¡¼¥¸¥Ü¥Ã¥¯¥¹
¤Çɽ¼¨¤·¤Æ¤¯¤ì¤Þ¤¹¡£

¥Õ¥¡¥¤¥ë¿ô¤Ï²¿¸Ä¤Ç¤âOK¤Î¤Ï¤º¤Ç¤¹¤¬¡¢»ä¤¬¼ÂºÝ¤Ë»î¤·¤¿¤Î¤Ï30¥³¤Þ¤Ç¤Ç¤¹¡£
------------------------------
Sub consolid()
Application.ScreenUpdating = False '²èÌ̹¹¿·¤ò°ì»þÄä»ß
Set mb = ThisWorkbook
myfdr = ThisWorkbook.Path
fname = Dir(myfdr & "\*.xls") '¥Õ¥©¥ë¥ÀÆâ¤ÎExcel¥Õ¥¡¥¤¥ë¤ò¸¡º÷
Do Until fname = Empty 'Á´¤Æ¸¡º÷¤·½ª¤¨¤ë¤È¡¢fname = Empty ¤È¤Ê¤ë¤Î¤Ç¡¢¤½¤Î´Ö°Ê²¼¤ò¼Â¹Ô
If fname <> mb.Name Then '¥Õ¥¡¥¤¥ë̾¤¬¤³¤Î¥Õ¥¡¥¤¥ë¤¸¤ã¤Ê¤±¤ì¤Ð
Set wb = Workbooks.Open(myfdr & "\" & fname) 'ÁªÂò¤·¤¿¥Õ¥¡¥¤¥ë¤ò³«¤¯
wb.Worksheets(1).Copy After:=mb.Sheets(mb.Sheets.Count) '¥³¥Ô¡¼¤·¤Æ¤Þ¤È¤áÍѥ֥å¯ËöÈø¤ËÃÖ¤¯
wb.Close 'ÁªÂò¤·¤¿¥Õ¥¡¥¤¥ë¤òÊĤ¸¤ë
n = n + 1 '¥Ö¥Ã¥¯¿ô¤ò¥«¥¦¥ó¥È
End If
fname = Dir 'ÁªÂò¤·¤¿¥Õ¥©¥ë¥ÀÆâ¤Î¼¡¤ÎExcel¥Õ¥¡¥¤¥ë¤ò¸¡º÷¤·¤Þ¤¹
Loop '·«¤êÊÖ¤¹
Application.ScreenUpdating = True '²èÌ̹¹¿·°ì»þÄä»ß¤ò²ò½ü
MsgBox n & "·ï¤Î¥Ö¥Ã¥¯¤ò¤Þ¤È¤á¤Þ¤·¤Þ¤·¤¿¡£"
End Sub
------------------------------

°ì±þ¡¢¼«¸ÊÀÕǤ¤Ç¼«Í³¤Ë¤´³èÍѤ¯¤À¤µ¤¤¡£m(_ _)m

5
µ×¤·¤Ö¤ê¤ËExcel¹ÖºÂ¡£(^_^)

1¹Ô¤ª¤­¤Ë¶õÇò¹Ô¤¬»Ä¤ë¤³¤ó¤Ê¥Ç¡¼¥¿¤¬¤¢¤ë¤È¤¹¤ë¡£
001
¶ö¿ô¹Ô¤¬Í¾Ê¬¤Ê¤Î¤Ç¼ê¤Ã¼è¤êÁ᤯ºï½ü¤¹¤ëÊýË¡¤ò¹Í¤¨¤ë¡£

½çÈÖ¤¬ÊѤï¤Ã¤Æ¤¤¤¤¤Î¤Ê¤é´Êñ¡£
AÎóÁ´ÂΤòÈÏ°Ï»ØÄꤷ¡¢¾º½ç¡Ê¤Þ¤¿¤Ï¹ß½ç¡Ë¤ËʤÙÂؤ¨¤ë¡£
002

¤¹¤ë¤È¤³¤ó¤Ê´¶¤¸¤Ç¤¹¤Ù¤Æ¶õÇò¹Ô¤Ï¾Ã¤¨¤ë¡£
003

¤â¤·½çÈÖ¤òÊѤ¨¤º¤Ë¡¢¶õÇò¹Ô¤À¤±ºï½ü¤¹¤ë¤È¤Ê¤ë¤È
¿¾¯ºÙ¹©¤¬É¬Íס£

¤Þ¤º¤Ïº¸Â¦¤Ë1ÎóÁÞÆþ¡£
004

Äɲä·¤¿Îó¤Ë»Ä¤·¤¿¤¤¹Ô¤Ë¡Ö0¡×¡¢¾Ã¤·¤¿¤¤¹Ô¤Ë¡Ö1¡×¤òÆþÎÏ¡£
¥ª¡¼¥È¥Õ¥£¥ë¤ò»È¤¨¤ÐĶ´Êñ¡£
005

¥Õ¥£¥ë¥¿¤Ç¡Ö1¡×¤Î¤ßÃê½Ð¡£
006

¤½¤³¤Ç»Ä¤Ã¤¿¹Ô¤òÁ´¤Æºï½ü
007

¤½¤·¤Æ¥Õ¥£¥ë¥¿¤ò²ò½ü¤¹¤ë¤È¡Ö0¡×¤Î¤ß»Ä¤ë¡£
008

ÁÞÆþ¤·¤¿AÎó¤òºï½ü¤¹¤ì¤Ð¥´¡¼¥ë
009


¥Þ¥¯¥í¤ò»È¤¨¤Ð¡¢¾åµ­¤Î¤è¤¦¤Ê¤³¤È¤Ï¼Â¸½¤Ç¤­¤ë¤¬
¥Þ¥¯¥í¤Ï½é¿´¼Ô¤Ë¤Ï¤Á¤ç¤Ã¤ÈÉߵ郎¹â¤¤¡£
¡Ö¥Õ¥£¥ë¥¿¡×ÄøÅ٤ʤéÆñ°×ÅÙ¤º¤Ã¤È²¼¤¬¤ë¤Ï¤º¡£
µ¡²ñ¤¬¤¢¤Ã¤¿¤é»È¤Ã¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£(^_^)

5
PC¥¤¥ó¥¹¥È¥é¥¯¥¿¤ò»Ï¤á¤ÆÁá10ǯ°Ê¾å¡£
Word¤ÈExcel¤ò»È¤ï¤Ê¤¤Æü¤Ï¤Ê¤¤¡¢
¤È¤¤¤¦¤Û¤ÉËèÆü¤Î¤è¤¦¤Ë»ÈÍѤ·¤Æ¤¤¤ë¡£
¤½¤ì¤Ê¤Î¤ËÀèÆü¥¨¥ó¥È¥ê¡¼¤·¤¿¤è¤¦¤Ë
¤¤¤Þ¤À¤ËÃΤé¤Ê¤¤Î¢µ»¤¬¤Ò¤ç¤Ã¤³¤ê½Ð¤Æ¤¯¤ë¡£
º£Æü¤Ï¥¨¥¯¥»¥ë¤Ç¡£(^-^)

¥¨¥¯¥»¥ë¤Ç¹ç·×¡¦Ê¿¶Ñ¡¦ºÇÂ硦ºÇ¾®¤ò½Ð¤¹¡£
°Ê²¼¤Î¤è¤¦¤Êŵ·¿Åª¤Ê¾ìÌÌ¡£
´Ø¿ô1


¤³¤³¤Ç»ä¤Ïɬ¤º¡¢Åú¤¨¤òɽ¼¨¤·¤¿¤¤¥»¥ë¤ò¥¢¥¯¥Æ¥£¥Ö¤Ë¤·¤Æ¡¢
¤½¤Î¤¢¤È¡Ö¥ª¡¼¥ÈSUM¡×¤Î¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¡¢¤È¶µ¤¨¤ë¡£

°ú¿ô¤òÈÏ°Ï»ØÄꤷ¤Æ¤«¤é¥Ü¥¿¥ó¤ò²¡¤¹
´Ø¿ô2

¤Î¤è¤¦¤Ê¤ä¤ê¤«¤¿¤Ï¡¢¡Ö¹ç·×¡×¤À¤±¤Ê¤é¤È¤â¤«¤¯¡¢
¾å¿Þ¤Î¤è¤¦¤Ë¡¢¡Ö¹ç·×¡×¡ÖÊ¿¶Ñ¡×¡ÖºÇÂç¡×¡ÖºÇ¾®¡×¤È
¹àÌܤ¬Áý¤¨¤¿¤È¤­¤Ëº¤¤Ã¤Æ¤·¤Þ¤¦¤«¤é¡£

¤È¤³¤í¤¬º£Æü¤È¤ó¤Ç¤â¤Ê¤¤¤³¤È¤òÃΤä¿¡£

²¿¤ÈÀè¤Ë°ú¿ô¤òÈÏ°Ï»ØÄꤷ¤Æ¤«¤é¡¢´Ø¿ô¤ò»ØÄꤷ¤Æ¤â
´Ø¿ô3

¤Á¤ã¤ó¤È¤¹¤°²¼¤ËÀµ¤·¤¤Åú¤¨¤òɽ¼¨¤·¤Æ¤¯¤ì¤ë¤Î¤À¡ª
¡ÖºÇÂç¡×¡ÖºÇ¾®¡×¤âƱÍͤˤǤ­¤¿¡£

¤µ¤é¤Ë¹ÔÎó¤òÆþ¤ìÂؤ¨¤Æ¡¢²£Êý¸þ¤Ë¿­¤Ð¤·¤Æ¤â
¤Á¤ã¤ó¤ÈÅú¤¨¤òɽ¼¨¤·¤Æ¤¯¤ì¤¿¡£
¤Ä¤Þ¤ê¡¢ÎÙÀܤ¹¤ë¥»¥ë¤Ê¤éÀè¤Ë°ú¿ô¤ò»ØÄꤷ¤Æ¤«¤é
´Ø¿ô¤òÁªÂò¤·¤Æ¤âÁ´¤¯ÌäÂê¤Ê¤¤¤Î¤À¡£

¤à¤·¤í¡¢´Ø¿ô¤ò»ØÄꤷ¤Æ¤«¤é°ú¿ô¤òÊѹ¹¤¹¤ëºÝ¤Ë
¼ºÇÔ¤¹¤ë³ØÀ¸¤¬Â¿¤¤¤Î¤Ç¡¢Àè¤Ë°ú¿ô¤ò»ØÄꤹ¤ëÊý¤¬
¥È¥é¥Ö¥ë¤Ï¾¯¤Ê¤¤¤«¤âÃΤì¤Ê¤¤¡£

¤Ç¤â´ðËÜ´Ø¿ô¤Ê¤é¤È¤â¤Ê¤¯¡¢IF´Ø¿ô¤Ê¤É¤Î°ú¿ô¤¬Ê£¿ô¸Ä
ɬÍפʴؿô¤Ø¤Î¤Ä¤Ê¤¬¤ê¤ò¹Í¤¨¤ë¤È¼ê½ç¤Ï·¤¨¤¿¤Û¤¦¤¬
º®Í𾯤ʤ¤¤«¡ª¡©

¤¦¡Á¡Á¤ó¡¢Çº¤à¡£
±ü¤¬¿¼¤¤¤Ê¤¡¡Á¡Á¡¢Excel¡£
¤³¤ì¤À¤«¤éË°¤­À­¤Î»ä¤¬¤³¤ó¤Ê¤ËŤ¯
¥¤¥ó¥¹¥È¤ä¤Ã¤Æ¤¤¤é¤ì¤ë¤ó¤À¤è¤Ê¡Á¡£¡Ê¾Ð¡Ë

¤Þ¤¿¼ø¶ÈÊýË¡¤òÎý¤ê¤Ê¤ª¤¹É¬Íפ¬½Ð¤Æ¤­¤¿¡£
¥Õ¡Á¡Á¡£
¤â¤Ã¤È¤â¤³¤Î»î¹Ôºø¸í¤¬ºÇ¹â¤Ë³Ú¤·¤¤¤ó¤À¤±¤É¤Í¡£¡À(o¢Þ¢à¢Þo)/

5
°ÊÁ°PDF¤ò¥Æ¥­¥¹¥ÈÊÑ´¹¤¹¤ëºÝ¤Ë¤Ï°­Àï¶ìÆ®¤·¤¿¤¬¡¢
¤¢¤ì¤«¤é2ǯ·Ð¤Á¡¢¤¹¤Ã¤«¤ê¾õ¶·¤ÏÊѲ½¤·¤¿¡£

PDF¤òWord¤Ë´Êñ¤ËÊÑ´¹¤·¤Æ¤¯¤ì¤ë¥µ¡¼¥Ó¥¹¤òȯ¸«¡£
¤³¤Á¤é¡½¢ª¡ÖPDFtoWord¡×
±Ñ¸ì¤Î¥µ¥¤¥È¤À¤¬»È¤¤Êý¤Ï¶Ë¤á¤Æ´Êñ¡£
STEP1¡¦¡¦¡¦¥í¡¼¥«¥ëPC¤«¤éÊÑ´¹¤·¤¿¤¤¥Õ¥¡¥¤¥ë¤ò»ØÄê
STEP2¡¦¡¦¡¦Word·Á¼°¤«¥ê¥Ã¥Á¥Æ¥­¥¹¥È·Á¼°¤«¤òÁªÂò
STEP3¡¦¡¦¡¦¼«Ê¬¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤ò»ØÄê
¤¿¤Ã¤¿¤³¤ì¤À¤±¡£
200KB¤Î¥Õ¥¡¥¤¥ë¤Ç1ʬ°ÊÆâ¡£
700KB¤Î¥Õ¥¡¥¤¥ë¤Ç¤â2ʬ°ÊÆâ¤Ë¥á¡¼¥ëźÉÕ¤µ¤ì¤ÆÊÖÁ÷¤µ¤ì¤Æ¤­¤¿¡£
¤È¤â¤ËZIP·Á¼°¤Ç°µ½Ì¡£

¥¯¥ê¥Ã¥×¥¢¡¼¥È¤Ê¤É¤Î¿Þ·Á¤â¤¢¤ëÄøÅÙ¤­¤Á¤ó¤ÈÊÑ´¹¤µ¤ì¤Æ¤ª¤ê¡¢
̵ÎÁ¥µ¡¼¥Ó¥¹¤Ç¡¢¤³¤Î¥¹¥Ô¡¼¥É¤Ç¤ä¤Ã¤Æ¤¯¤ì¤ë¤Ê¤é¸æ¤Î»ú¡£
¥Ð¥ó¥¶¡¼¥¤ ¡À(¡æ¢à¡å)/¡À(¡æ¢à¡å)/¡À(¡æ¢à¡å)/¡À(¡æ¢à¡å)/ ¥­¥ã¥¡¢ö

¤µ¤é¤Ë»ÐË奵¥¤¥È¤Ç¤Ï¤Ê¤ó¤È¡ÖPDFtoExcel¡×¤â¡£
¤³¤Á¤é¤Ïɽ·Á¼°¤Ï¤­¤Á¤ó¤ÈÊÑ´¹¤·¤¿¤¬
¤µ¤¹¤¬¤Ë¥°¥é¥Õ¤ÏÊÑ´¹¤·¤Æ¤¯¤ì¤Ê¤«¤Ã¤¿¡£
¤³¤ì¤Ï»ÅÊý¤Ê¤¤¤Í¡£(^^;)

Word¡¦Exce¢ªPDF¤ÏOffice¼«ÂΤ¬¤¹¤Ç¤Ëɸ½à¤Ç¥µ¥Ý¡¼¥È
¤·¤Æ¤¤¤ë¤¬¡¢µÕ¤Ï¶ìÏ«¤·¤Æ¤¤¤¿¡£
Í­ÎÁ¤Î¥½¥Õ¥È¤Ï¤¢¤ë¤â¤Î¤Î¡¢¤½¤ó¤Ê¤ËÉÑÈˤˤĤ«¤¦¤Î¤Ç
¤Ê¤¤¤Î¤Ê¤é¤ï¤¶¤ï¤¶Ç㤦¤Î¤âÀˤ·¤¤¡£
º£²ó¤Î¥µ¡¼¥Ó¥¹¤Ï¡¢¥¯¥é¥¦¥É¤Ç½èÍý¤µ¤ì¤ë¤Î¤Ç
¥½¥Õ¥È¤Î¥¤¥ó¥¹¥È¡¼¥ë¤âÉÔÍפǤµ¤é¤Ë̵ÎÁ¤È¤­¤Æ
¿½¤·Ê¬¤Ê¤¤¡£

100¡ó´°Á´ºÆÀ¸¤È¤Ï¸À¤¨¤Ê¤¤¤â¤Î¤Î¡¢
½¼Ê¬¼ÂÍѤËÂѤ¨¤ë¥ì¥Ù¥ë¤À¤È»×¤¦¡£

µ¡²ñ¤¬¤¢¤Ã¤¿¤é¤¼¤Ò»È¤Ã¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£(*^^)

¢¬¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø