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

[µo°Ý] excel¥ð°²ªí°ÝÃD

[µo°Ý] excel¥ð°²ªí°ÝÃD

·Q¦A¤u§@ªí1ª½±µKEY¤J¥ð°²¤é µM«á¦A¤u§@ªí2(©T©wªí®æ)¿é¤J¤ë¥÷(¦p¹Ï)¡A´N·|¦Û°Ê±a¥X©Ò¦³¤H­û¥ð°²¤é´Á¡A¤u§@ªí3­pºâ¯S¥ð¤Î¾ã¦~«×©Ò¦³¥ð°²

Â^¨ú.JPG (59.32 KB)

Â^¨ú.JPG

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-3-8 15:06 ½s¿è

¸Õ¸Õ¬Ý:
https://www.youtube.com/watch?v=5PitdlOs9Dk
http://www.mediafire.com/downloa ... 105%E5%B9%B4%29.rar

TOP

·PÁ¤j¤j¦^´_ §Ú¥ý¬ã¨s¤@¤U ¦³°ÝÃD¦A½Ð±Ð§A

TOP

±z¦n¡A·Q½Ð¼Ó¥D¸É¥R¤@¤U¤u§@ªí1¤Î3ªº®æ¦¡¡C¹Ï¤ù¶È¦³¤u§@ªí2¡C

TOP

¦^´_ 5# ¾Ç¨ì¦Ñ¦º


    ¥u¬OÄÄ­z·Q­nªºªí®æ¡A©Ò¥H¨S¹Ï¤ù¡AYEN¤j¤jªºªí®æ¥u¯à°w¹ï¯S¥ð¨Æ°²µ¥¥h²Î­p¦~«×¤Î¦U§O¤ë¥÷ªº³¡¤À..

TOP

yen956¤j¤j¡AÀɮצn¹³¨S¿ìªk¤U¸ü©O¡I

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-3-18 14:56 ½s¿è

¦^´_ 6# tochiao

http://www.mediafire.com/downloa ... 107%E5%B9%B4%29.rar

http://www.mediafire.com/downloa ... 106%E5%B9%B4%29.rar

http://www.mediafire.com/downloa ... 105%E5%B9%B4%29.rar

Sorry!!¤v­«·s¤W¶Ç, ¤µ¤Ñmediafire¦n¹³¦³°ÝÃD, §A§ï¤Ñ¦A¸Õ¸Õ¬Ý!!

TOP

½Ð°Ý¤j¤j¡A¦pªG®É¶¡¬O10¤p®É ¡AVBA­þ­Ó³¡¥÷­n­×§ï¡A¹³§Ú¥´¦~¥ð10¡A´N¤@¤ùªÅ¥Õ

TOP

¦^´_ 8# Qektyyrwp
¸Õ¸Õ¬Ý:
1. ¥X¯Ê¶Ô§O­p®É³¡¥÷, ¥½2¦ì¥þ³¡½s­×¬°
¦~¥ð10
¦~¥ð04
¦~¥ð08
¨Æ°²02
¨Æ°²04
... ...
... ...
¨Æ°²AA

«D­p®É³¡¥÷¤£ÅÜ

2. vba³¡¤À
¥Î --RIGHT ·j´M,
±N --RIGHT(E7,1) §ï¬° --RIGHT(E7,2)
(§Y, ­ì¥k¨ú1¦ì, §ï¬°¥k¨ú2¦ì)
(¦@3³B)
    ActiveWorkbook.Names.Add Name:="rr", RefersToR1C1:="=--RIGHT(ww,2)"
    ActiveWorkbook.Names.Add Name:="rm", RefersToR1C1:="=--RIGHT(wm,2)"
3. ½s¿è§¹½Ð«ö ¸ê®Æ­«¾ã

TOP

¦^´_ 9# yen956


    ¥i¥H¤F ÁÂÁÂÀ°¦£

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD