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

[µo°Ý] ¿z¿ï¸ê®Æ°ÝÃD

[µo°Ý] ¿z¿ï¸ê®Æ°ÝÃD

½Ð±Ð°ª¤â¤j¤j
¦p¦ó,±NA¤u§@ªí¥N½X²M³æ,°µ¬°±ø¥ó,¦bB ¤u§@ªí¿z¿ï¸ê®Æ

¤½¥q¤¬°Ê¿z¿ï.rar (909.15 KB)

¦^´_ 1# blue2263

¦Û¤v¿ý¤@¤U¿z¿ï´N¦n¡I

¨Ò¦p¡G¬d2002¤¤¿û¡A
¦pªG¬d¨ì2002(aÄæ)¡A½Ð±N¥k¤è²Ä¤TÄ檺(DÄæ)¿ûÅK¤u·~¿ï¨ú
¥H¿ûÅK¤u·~¬°¿z¿ï­n¯À¡A±N©Ò¿ï¨ìªº¸ê®Æ½Æ»s¨ì§Aªº­n¤u§@ªí«á¡A¦A±N²Ä¤@±iªí¨ú®ø¿z¿ï§Y¥i

TOP

¦^´_ 1# blue2263
¥i°Ñ¦Ò
Autofilter ¤èªk

TOP

¦^´_ 1# blue2263
¤u§@ªí¿z¿ï¸ê®Æ¡A ¸Õ¸Õ¬Ý¡I
¥H²£·~§O¡B¥H¤Î¥«³õ§Oµ¥¬°½d¨Ò¨Ó¿z¿ï¸ê®Æ¡C
¤½¥q¤¬°Ê¿z¿ï.rar (450.34 KB)

TOP

·PÁÂC¤j,¤£¹L§Ú·Q§Ú´£°Ý°ÝÃD,¤£°÷¸Ô²Ó,G¤j»~¸Ñ§Úªº»Ý¨D,
¥H¤U¦A¸Ô­z§Úªº°ÝÃD
¤ñ¦p§Ú¦b(¹ï¤â¦P²£·~¤u§@ªí),¥N½XÄæ,¿z¿ï¥X1101¬ÛÃöªº¹ï¤â¦P²£·~®a¼Æ(¦p¤U¹Ï)

µM«á¥Î¤W¹Ï©Ò¿z¿ï¥Xªº¦P·~²M³æ(¦@7®a),¦b(¿ïªÑ³øªí¤u§@ªí),¤@¼Ë¥Î¿z¿ïªº¤è¦¡§ä¥X³o7®a¸ê®Æ

¤§«e¤]¦³¥Î¿ý»s¥¨¶°ªº¤èªk¦p¤Uµ{¦¡½X,¦ý¤£ª¾¦p¦ó¤~¯à±N,(¹ï¤â¦P²£·~¤u§@ªí)§ä¥Xªº¦P·~¥N½X¸ê®Æ,»P¤U­±µ{¦¡½Xµ²¦X
    ActiveSheet.Range("$A$2:$XFC$1602").AutoFilter Field:=1, Criteria1:=Array( _
        "1101", "1102", "1108", "1110"), Operator:=xlFilterValues

TOP

PS:¦]§Ú¹ï¤â¦P²£·~,¦³¦A²Ó¤À,©Ò¥HµLªkª½±µ¥Î(¿ïªÑ³øªí¤u§@ªí)ªº²£·~§O§ä¥X¬Û¦Pµ²ªG

TOP

¤£ª¾¬O§_¦³¸Ñ?ÁٽФj¤jÀ°¦£,·P®¦ÁÂÁÂ!!

TOP

¦^´_ 7# blue2263
»¡¯uªº¡A§A±q#5 ~ #7 ¶¡ªº´y­z¡A
§Ú¬Ýªº "ÀÛ»ã»ã"¡A§A¥i§_±qÀY¨ì§À
±N»Ý¨D¥Î¹Ï¥Ü¥H¤Î»¡©ú´y­z¤@¦¸¡H

TOP

¥»©«³Ì«á¥Ñ blue2263 ©ó 2016-7-28 21:15 ½s¿è

C¤j§A¦n,¤£¦n·N«ä,§Úªí逹ªº¤£¦n,´y­z¤£°÷²M·¡,§Ú¦A´y­z²M·¡¤@ÂI,ÁÂÁÂ
¥H¤U¥H¾Þ§@¨BÆJ»¡©ú
¨BÆJ1,¹ï¤â¦P²£·~¤u§@ªí,(AÄæ)¿z¿ï1101¸ê®Æ->¿z¿ïµ²ªG,¦@7®a¦P·~¸ê®Æ(BÄæ)

¨BÆJ2.¦b¿ïªÑ³øªí¤u§@ªí,¥Î¿z¿ïªº¤è¦¡,¥H¤W¹Ï7®a¿z¿ïµ²ªG²M³æ(BÄæ)°µ¬°±ø¥ó,§ä¥X¦¹7®a¼t°Ó(¦p¤U¹Ï)

¨BÆJ1¬°¤â°Ê¾Þ§@,¨BÆJ2§Æ±æ¥ÎVBAªº¤è¦¡°õ¦æ

¤£¦n·N«ä,´y­z¤£°÷²M·¡,®ö¶OC¤j®É¶¡,¤U¦¸´£°Ý°ÝÃD·|§ï¶i!!
ÁÂÁÂ!! C¤j¼ö¤ßÀ°¦£

2.JPG (94.53 KB)

2.JPG

TOP

¦^´_ 9# blue2263
³o¬O¤£¬O§A­nªºµ²ªG¡H


¤½¥q¤¬°Ê¿z¿ï.rar (1.3 MB)

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD