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

¸ê®ÆÂà¼g+VBA¤ë¥÷¬y¤ô¸¹

¸ê®ÆÂà¼g+VBA¤ë¥÷¬y¤ô¸¹

¥»©«³Ì«á¥Ñ man65boy ©ó 2012-5-5 21:23 ½s¿è

¦p¦ó¦bÀɮתºAÄæ¸Ì³]¸mVBA¦Û°Ê§PŪªº¬y¤ô¸¹,¤p§Ì¦³¸Õ¹L¨ç¼ÆÀ³¥Î¡A¦ý¡A¦]¬°¤Ä¿ï"¦Û¨ú"«á¡AÂà¼g¨ìSheet2®É¡A¨ç¼Æ·|­«·s¦A½s¸¹¡A³o¼Ë·|¨Ï¸ê®ÆµLªkÅܦ¨·íªì©Ò½sªº½s½X¡C
½Ð±Ð¦U¦ì¥ý¶i¦Ñ®v­Ì¡A¦p¦óÅýAÄ檺¬y¤ô¸¹¡A¦bÂà¼g«á¡A¨Ì«O«ùµÛ­ì¨Óªº½s½X¡AÁÂÁÂ!
¸ê®ÆÂà¼g¥[¬y¤ô¸¹.rar (11.25 KB)

¦^´_ 2# play9091


    ÁÂÁ¤j¤jªº­×§ï«Øij¡A¦ý¬O¡A ¤p§Ì¦bAÄæ¨Ï¥Îªº¨ç¼Æ=TEXT(B2,"mm")&"-"&TEXT(SUMPRODUCT((TEXT($B$1:$B2,"yymm")=TEXT(B2,"yymm"))*1),"000")¡A¸ê®Æ¤£Âà¼g¨«ªº¸Ü¡A¨S°ÝÃDªº¡A
  ¥i¬O SHEET1ªºAÄæ¨ç¼Æ¬O·|ÀHµÛÂà¼g¨«ªº¸ê®ÆÅÜ°Ê­«±Æ¡A©Ò¥H¤p§Ì§Æ±æ¯à¦bAÄæ¨Ï¥ÎVBA¬y¤ô¸¹¡A

TOP

¦^´_ 4# oobird


    ÁÂÁÂoobird¤j¤jªº¦^µª¡AÂà¼g¨ìsheet2ªº¸ê®Æ¥¿½TµL»~¡A¦ý¡Asheet1ªº¸ê®Æ¥u­n¦b«ö¶s¤@¤U¡A´N­«·s±Æ¦C¤F¡A³o¼Ë·|¨Ïsheet1ªº½s¸¹¸ê®Æ¸òsheet2½s¸¹¸ê®Æ­«½Æ¡A
¤p§Ì·Q±o¤£°÷¦h¡A»¡ªº¤£²M·¡¡A©êºp!
   ¬y¤ô¸¹­«·s»¡©ú:sheet1ªºA Äæ½s¸¹¬°2012-05-001<<¥[¤W¦~¥÷(³o¼Ë¤ñ¸û¹³°ß¤@½X)¡A¤@¼ËÂà¼g«á¡A¦b«ö¶s½s½X®É¡A¤£¯à©Msheet2½s¸¹¸ê®Æ­«½Æ¡A²³æ¨Ó»¡¡AÂà¼g2012-05-002¨ìsheet2®É¡A
sheet1AÄæ¸Ì¤£¯à¦b¦³¬Û¦Pªºsheet2AÄ檺¬y¤ô¸¹¡A³o¼Ë¤~¯à«O¯d·íªì³]©wªº½X¸¹¬O°ß¤@¡A³Â·Ð¦U¦ì¦Ñ®vÀ°¦£!


¸ê®ÆÂà¼g¥[¬y¤ô¸¹2.rar (11.46 KB)

TOP

¦^´_ 6# register313


    ·PÁÂregister313¤j¤j§¹¬üªº¸Ñµª¡A¥i§_½Ð¤j¤j¦bµ{¦¡½X¤¤³Æµù»yªk¡A¦nÅý¤p§Ì¾Ç²ß¡A¦A¦¸ªº·PÁ§A¡C

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD