- ©«¤l
- 193
- ¥DÃD
- 29
- ºëµØ
- 0
- ¿n¤À
- 222
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows7
- ³nÅ骩¥»
- OFFICE2013
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-9-18
- ³Ì«áµn¿ý
- 2023-4-29
|
¦^´_ 6# yifan2599
·|³o¼Ë¸ß°Ý¬O¦]¬°, ³Ì«á¤@¶µ¥\¯à
Q3 : ¤]´N¬O³Ì«nªº§ó·s¥X¶Ô¥\¯à
¦p¤U¹ÏUserfrom ¤w¸g©Ô¥X¨Ó¤F,
3-1. ºñ®Ø¬O§_¯à¥´¶}´N¹w³]·í¤éªº¤é´Á, ®ÇÃä¬P´Á¦Û°Ê§PÂ_±a¥X¨Ó
3-2. ·í¿ï¾Ü½s¿è²Õ§Oªº¦P®É, ¬O§_¯à±N¡y¤H¤O¸ê®Æ®w¡z³o±iSheet, ¦p«e±¿ï¾Üªº±ø¥ó(¯Z§O/»â¯Z/²Õ§O)
¦b¤U±ªº²M³æ¤è¶ô¤¤¦C¥X¨Ó, ¦pªGÂI¿ï²M³æ«ö¶s( OptionButton ) ´N¯à¦Û°ÊÅã¥Ü¦b²M³æ¤è¶ô¤¤,
«h¬õ®Ø¤¤ªº¡y½T»{²Õ§O¡z«ö¶s«h¥i¥H§R°£
3-3. §e²{¦b²M³æ¤è¶ô¤¤ªº¶µ¥Ø, ¥i§_ÂI¿ï¨â¤U, ´N¯à¦Û°Ê±a¤JÂŮةҰé¿ïªº¶µ¥Ø, ÂŮؤ¤ªº¶µ¥Ø¤]¬O±q¡y¤H¤O¸ê®Æ®w¡z³o±iSheet
¾É¤J¬ÛÃö¸ê°T, ¨ä¤¤¡y¥X¶Ô¯¸§O¡z¬O¾É¤J¡y¤H¤O¸ê®Æ®w¡z³o±iSheetªº¡y¥Dn±Mªø¡z, ¤£¤@¼Ëªº¦a¤è¬O¥i¥H³z¹L®ÇÃ䪺«ö¶s§ó§ï(¥X¶Ô±Mªø)
¡° ¦p¤£¥i¥H¦b²M³æ¤è¶ôÂI¨â¤U´N±a¤J¤U±¸ê°T, «h¥i¦b¥t³]¤@Ó«ö¶s±a¤J
3-4. ·í«ö¤U½T»{§ó·s, «h¦s¤J¡y¥X¶Ô¸ê®Æ®w¡z³o±iSheet¤º, ¬Û¹ïÀ³ªºÄæ¦ì, ¦p¹Ï2
¡° ¹Ï3 ´N¬O¾É¤J¹ïÀ³Äæ¦ì¸ê°T
¹Ï1
¹Ï2
¹Ï3
3-5. ¦A¥[¯Zpºâ¤è±, ¤U¹Ï¬O§_¥i¥H¨t²Î¦Û¦æ§PÂ_, ¦pªG¤£¦æ«h§â¦¹¥\¯à«Ø¥ß
¤W¥b¦~«×, VPK¥ð®§¤é¬O , V ¶g¤» , P ¶g¤é , K ¶g¤G
¤U¥b¦~«×, VPK¥ð®§¤é¬O , V ¶g¤é , P ¶g¤» , K ¶g¤G
¦p¤W, ¥[¯Z®É¼Æ¦U²Õpºâªº¤é´Á¤£¦P, ¦p¤W¥\¯à¡y¥X¶Ô®É¼Æ¡z´Nnpºâ¥ð®§¤é(ºâ¥[¯Z),
¦U²Õ§Oªº¥ð®§¤é+¦³¥´¤Äªº¶ñ¼gªº¥[¯Z®É¼Æ = ¥[¯Z®É¼Æ
¡y¤Hû¦^³ø¡z³o±iSheet , ¤é´ÁÄæ¦ì¬O§_¥i¥H¨t²Îµ{¦¡¦Û°ÊÂà´«¤ë¥÷¤Î¤é´Á??
¨Ì·ÓA2Äæ¦ìÅã¥Üªº¤ë¥÷, ¥un§ó§ïA2Ä檺¤ë¥÷, ¤U±¸ê®Æ·|¦Û°Ê¾É¤J¡y¥X¶Ô¸ê®Æ®w¡z¸ê®Æ
¸ê®ÆÄæA63,B63,D63,E63,F63,G63, ±q¡y¤H¤O¸ê®Æ®w¡z³o±iSheet, ¾É¤J¥B¦Û°Ê±Æ§Ç
±Æ§Ç¶¶§Ç:
1. ¯Z§O:1ST,2ND,3RD,
2. »â¯Z:A,B,C.....
3. ¦U»â¯Zªº²Õ§O, ¤À§O V P K
¦A¨Ó´N¬O¨Ì·Ó¡y¥X¶Ô¸ê®Æ®w¡zSheet©ÒºûÅ@ªº¡y¥X¶Ô¯¸§O¡z(GÄæ)³oÄæ¾É¤J©ÒºûÅ@ªº¸ê®Æ
³Ì«á¤@¶¸ê®Æªí¡y¾ã¦X¶±¡z, ¥u·|§e²{¤»,¤é,¤@,¤G ³o¥|¤Ñªº¸ê®Æ, «e±¬Û¦P¸ê°T¤@¼Ë¨t²Î¾É¤J°ò¥»¸ê®Æ
¦p¤U¹Ï½d¨Ò
¨D¸Ñ....
¤Hû¤H¤O¦^³øªí_V2.rar (455.51 KB)
|
|