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

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

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

¦p¹Ï¤Îªþ¥ó ¦p¦ó±NA,BÄæÂà´«¦¨¨S¦³ªÅ®æ¤Î­n¯S©w±Æ¦C¤§C,DÄæ

1. ¥h°£A,BÄ椺ªÅ¥Õ¤§®æ
2. CÄ椧­È¬O¥Ñ¤j¦Ü¤p DÄ椧­È¬O¦P¨B©óCÄæ(¸òµÛCÄæ²¾¦ì)
3. A,BÄ椧­È¬O­ÓÅÜ¼Æ ·|¨Ì¾Ú³]©w¤è¦¡¦Ó§ïÅÜ ¬GC,DÄ椧Á`®æ¼Æ¤]·|¸òµÛÅÜ
4. A,BÄ椧Á`®æ¼Æ ­Y¬OÅÜ¼Æ ·|³y¦¨¤£©ö¼gµ{¦¡ ¨º§Ú¥i¥H©T©w ¦ý³Ì¦n¤]¤¹³\A,BÄ椧Á`®æ¼Æ¥i¥H¬OÅܼÆ
5. ¦b¦¹¥ý·PÁ¤j®a¿ãÅDªº´£¨Ñ¤èªk À°¤p§Ì§Ú§¹¦¨¤£¥i¯àªº¥ô°È (§Ú¤wªá¶O¼Æ¤Ñªººë¯«»P®É¶¡ ¦ýÁÙ¬OµLªk§¹¦¨)





¹ïÀ³¤§¥i§ë¤Jª÷ÃB.zip (17.8 KB)

­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

¦^´_ 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

¦^´_ 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

¦^´_ 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

¦^´_ 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

¦^´_ 11# lcctno


   


°t¸mTEST.rar (64.66 KB)

TOP

¥»©«³Ì«á¥Ñ 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

¦^´_ 9# lcctno


    00631L©Î0050¤§¸êª÷°t¸m (1).zip (86.6 KB)

TOP

¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-17 12:36 ½s¿è

¦^´_ 8# lpk187
¦pªþ¥ó ¥u¥Î¿ï¾Ü©Ê¶K¤W­È¤Î®æ¦¡¤Îµù¸Ñ
-½Ð¬ÝSheet2¥ª¤W¤è ¶À®æ¤º¤§­È¬Ò¥i¯à§ó§ï

  ÁÂÁ±z  ³Â·Ð±z¤F

¦³¨Ç¤p°ÝÃD
1.Sheet1¤º u3¤Îv3 ¬°¦ó·|ªÅ¥Õ
2. ªÑ»ù2.99          §ë¤Jª÷ÃB999 ,477
¨Ã¥¼³Q¥N¤Ju¤Îv¤º


        00631L©Î0050¤§¸êª÷°t¸m.zip (81.92 KB)
                 




   



TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD