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

AutoFilter§¹§R°£¤£»Ý­nªº¥N¸¹¡A¦ýÁÙ¬O§R°£¤F

AutoFilter§¹§R°£¤£»Ý­nªº¥N¸¹¡A¦ýÁÙ¬O§R°£¤F

½Ð°Ý¦bªþ¥ó¤¤¡A°U¥~³øªíªº¶µ¥Ø§Ú¨Ï¥Î¤F¿z¿ïAAÄæ¨Ã±N¸ê®Æ§R°£
¦ý§R°£¶µ¥Ø¤¤¨S¦³¼g¨ìªº»sµ{¥N¸¹¡A¦pBG01»PBD81
¦ý«o·|¦³³Q§R°£¨ì¡A½Ð°Ý¬O­þ¸Ì¦³¤F°ÝÃD?
ºô¸ô¤W¦³¤H»¡ºÉ¶q¤£­n¥ÎAutoFilter¡A³o´N¤£¤ÓÀ´­ì²z
©Î¬O¦³¤°»ò¤è¦¡¥i¥H±Æ°£±¼³o­Ó°ÝÃD¡A¦A³Â·Ð¸Ñ´b....
CD.rar (243.16 KB)

¦^´_ 1# cclo0728

BG01»PBD81¦]¬°±ÄÁʸɥR¬°0³Q§R°£

    '¿z¿ï0§R°£
    Rows("1:1").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$U$3000").AutoFilter Field:=2, Criteria1:="0"
    Range("A2").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.EntireRow.Delete
    ActiveSheet.Range("$A$1:$U$3000").AutoFilter Field:=1
    Range("A1").Select
    Selection.AutoFilter

TOP

¦^´_ 2# jcchiang
·PÁÂ,¥uª`·N¨ì«eºÝ¡A¨Sª`·N¨ì«á­±ªº¿z¿ï§R°£
©¿²¤¤F¡AÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-6-11 15:09 ½s¿è

¬Ý¤£À´vlookup°µÔ£¥Î???
±ø¥ó´N´X­Ó, ¥Î´X­Ó§PÂ_±Æ°£§Y¥i, ­ìªí¤£°Ê:
CD_01.rar (247.29 KB)

¥u°µÁ`ªí¸ê®Æ¶×¤J, ¨ä¥¦Âø¶µ(®æ¦¡±ø¥ó), ¦Û¦æ¥h°µ~~

TOP

¦A¥[´X­Ó³B²z:Äæ¼e/¤é´Á¤ñ¹ï¥[ÃC¦â:
CD_01.rar (259.92 KB)

TOP

¦^´_ 5# ­ã´£³¡ªL
·PÁ­ã¤j«ü±Ð¡A¥Ø«e¤p§Ìªì¾ÇªÌ¥¿¦b¾Ç²ß¡A
¦³¶R®Ñ¨Ó¬Ý¡A¦ýµ{«×¬Ý±o¦³ÂI¦Y¤O¡A§l¦¬§A­Ìªº¸gÅç¡AÁÂÁ¦^ÂÐ

TOP

¦^´_ 6# cclo0728


¤@¦æ¤@¦æ¥[¤Jµù¸Ñ, ­Y³£¬Ý³q¤F, À³¥i³B²zÃþ¦üªº¨ä¥¦°ÝÃD:
CD_02.rar (147.01 KB)

TOP

¦^´_ 7# ­ã´£³¡ªL
·PÁ¡A¦n²M·¡
ÁÂÁ­ã¤j«ü¾É

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD