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

[µo°Ý] ¦p¦ó±NA,BÄæÂà´«¦¨¨S¦³ªÅ®æ¤Î­n¯S©w±Æ¦C¤§C,DÄæ

¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-18 11:50 ½s¿è

¦^´_ 10# lpk187

§Úµo²{Sheet1¤§­n¨Ï¥Î¤§Äæ¦ì¦³¿ù»~ ¬G¸É¤W¤F¤@¾ã±Æ¤§ªÅ¥ÕÄæ¦ì«á¤]¶i¥h­×§ï¥¨¶° ¦ý­n°õ¦æ¥¨¶°®É«o¬Ý¤£¨ì¥¨¶° ¬G¥u¦n¦Û¤v¶ÃCOPY °µ¤F¤@­Ó¥¨¶° ¦ý°õ¦æ°_¨Ó¨S¬Ý¨ì¦³¤°»ò°Ê§@
¥Ø«e½Ð±z¥H¥¨¶°ªº¤è¦¡¤U¥h¼g «Ý¥¿±`«á §Ú¦A½Ð±Ð±z¦p¦ó¯à·í°Ñ¼Æ ¤@§ïÅÜ µ²ªG¤]·|°¨¤W¸òµÛÅܪº¤èªk ÁÂÁ±z¤F




ªþ¤W§Ú¶Ã§ï¹LªºÀÉ®×


°t¸mTEST.rar (61.34 KB)

TOP

¦^´_ 11# lcctno


   


°t¸mTEST.rar (64.66 KB)

TOP

¦^´_ 12# lpk187

¬°¦ó§Ú¦bVB¬Ýªº¨ìSheet1ªº¥¨¶° ¦ý­n°õ¦æ¥¨¶°®É«o¬Ý¤£¨ì ¦pªþ¹Ï
§Ú¬Ý±zÁÙ¬OÀ°§Ú§Ë­Ó¥i¥H¥Î ¤u¨ã/¥¨¶°/¥¨¶° µM«áÂI¿ï¸Ó¥¨¶°¨Ó"°õ¦æ"

²³æªº §Ú¥i¯à·| ¦ýµy·LÃøªº§Ú¯uªº¤£·| ³Â·Ð±z¥ý¥Î²³æ¤@ÂIªº¤è¦¡ ¦n¤è«K§Ú¤Jªù ¹ïªì¾Çªº§Ú §Ú¯uªº«Ü·Q¾Ç·| ¦ý¤J¤£¤Fªù ¯uªº«D±`ªºÁÂÁ±zªº¥Î¤ß±Ð¾É§Ú






TOP

¦^´_ 13# lcctno

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
¬OÄÝ©ó"¤u§@ªí¨Æ¥ó"ªºµ{§Ç¬O¤£·|¦b¥¨¶°¤¤¥X²{¡A·|¦b¥¨¶°¤¤¥X²{ªº¥u¦³Module1¡BModule2... ©ÎªÌ¬Oµ{§Ç¥HPublic Sub  xxxx  ¤¤¤~·|¥X²{   
¦Ó¥HPrivate Sub xxx¶}ÀYªºµ{§Ç¤]¤£·|¥X²{¦b¥¨¶°Ã¯¤¤¡A³o¸Ì½Ð°Ñ¦ÒVBA»¡©ú¡A"Sub ³¯­z¦¡"
Worksheet_Change¤u§@ªí¨Æ¥ó­Y­n¦b¨ä¥Lªº¤u§@ªí¤¤¨Ï¥Î¥²¶·­n¾ã­Ó½Æ»s¹L¥h¡A¥¦¬OÄÝ©ó¨p¦³»â°ìªºµ{§Ç¡A¥H¨Æ¥ó¨ÓIJµo¡A¦Ó¤£¬O§Q¥Î«ö¶s¡A³o¸Ì½Ð°Ñ¦ÒVBA¦Ò»¡©ú¤¤ªºWorksheet.Change ¨Æ¥óªº

TOP

¦^´_ 14# lpk187

§Ú¬Oªì¾ÇªÌ ¥Ø«e¨S¦³¯à¤O±N¤§Âà´«¦¨§Ú¯à¨Ï¥Î¤§¥¨¶°
¥B§Ú¦³¹Á¸Õ±N±zªþ¤WªºÀÉ®×T,U¦æ¤§¼Æ­È§ïÅÜ ¦ýV,W¦æ¤º¤§­È¨ÃµLªk¦Û¦æÅÜ§ó ¨º¤Ï¦Ó³y¦¨§Ú¤£´±¨Ï¥Î¸Ó¼Æ¾Ú
§Ú¬Ý§ÚÁÙ¬O¥Î³Ì°ò¥»ªº¤H¤u¸ê®Æ±Æ§Ç«á½Æ»s¶K¤W ©Î¥i¨Ï¥Î¿ý»s·s¥¨¶°ªº¤è¦¡¨Ó³B²z §K±o§Ú¥i¯à°µ¥Õ¤u ÁÙ¥i¯àÃa¤F§Ú­ì¨Ó¥i±o¨ìªº¥¿½T²Î­p ¨º±N¥i¯à·|¿éªº¤£©ú¤£¥Õ
±z»¡©O? ¨º¬O¿úªº¾Ôª§ ½Ð¤£­n©Ç§Ú¬D­ç
ÁöµM§Ú¨S¯à©¯¹Bªº±o¨ì§¹¬üªº¸Ñµª ¦ý§Úª¾¹D±z¬O¥Î¤ßªº·QÀ°§Ú¸Ñ¨M°ÝÃD ¯uªº§ÚÁÙ¬O«Ü·PÁ±zªºÀ°§U

TOP

¦^´_ 14# lpk187
§Ú¥Ø«e¬O¦b·Q¿ìªk±N§Ú¹L¥h¥Î¶Ç²Îªº°ò¥»»yªk(Àɮׯuªº«Ü¤j ¦³¤@Àɤw770mbs ¥BÁÙ¤£¬O§Ú¯uªº³ßÅwªº¤ÀªR¤è¦¡) ¶}±Ò¶O®É §ïÅܤº®e¤§data Àx¦s®É¶¡¤]«Ü¶O®É ©Ò¥H¤~·Q¹Á¸Õ¨Ï¥Î¥¨¶°ªº¤è¦¡¨Ó¼g  ¦ýÁ`¤£¯à¬°¤F´î¤ÖÀÉ®×Åé¿n(mbs©Î³\§ï¤ÑÅܦ¨gbs) ¦Ó±o¨ì¨S¥i«H«×ªº¸ê®Æ§a! ¸ôÁö»· ¦ýºCºC¨«©Î³\ÁÙ¬O¥i¯à·|¥­¦wªº¨ì¹F¥Øªº¦a§a! ¯uªºÁÙ¬O«Ü·PÁ±z ­Y±z§ï¤Ñ·Q¤¶¤JªÑ¥«¬ÛÃö¤§²£ª« §Ú¥i´£¨Ñ§ÚªºÁÈ¿ú¤ßªk
³o¬O¨ä¤@"·Qªk¤£§ïÅÜ °µªk·íµM¤]¤£·|ÅÜ ¨º¿é®a«ç»ò·|Åܦ¨Ä¹®a"

TOP

­Y¤£¥Îvba¡A¥B¬°°ÊºA¼Æ¾Ú¡A¥[­Ó»²§UÄæ§Y¥i¡G
¢ë¢²¤½¦¡¡G¤U©Ô¦Ü¸ê®Æ§Àµ§
=IF(OR(A3="",B3=""),"",A3*10^8+ROW())
¡@
¢ì¢²¤½¦¡¡G¥k©Ô¢í¢²¦A¤U¨ê
=IF(ROW(D1)>COUNT($c:$c),"",INDEX(A:A,RIGHT(LARGE($c:$c,ROW(D1)),5)))
¡@

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD