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

[µo°Ý] ¦b¦P¤@¦C¦P®É¤ñ¹ï¨âÄæ¸ê®Æ¤èªk

¦^´_ 16# GBKEE
½Ð±Ð¡G
        Sheets(a).Range("A1").CurrentRegion.AdvancedFilter xlFilterCopy, Rng(1), Rng(2).Cells(1).Resize(1, Rng(1).Columns.Count)
¬O¤£¬O­n­×§ï¦¨¡G
        Sheets(2).Range("A1").CurrentRegion.AdvancedFilter xlFilterCopy, Rng(1), Rng(2).Cells(1).Resize(1, Rng(1).Columns.Count)
§_«h¤U¤@­Ó¤u§@ªí³æ¦p¬°ªÅ¥Õ¡A«h·|¦³¿ù»~°T®§¡C

TOP

¦^´_ 16# GBKEE
¬Ý¤F#17¼Óªº½d¨Ò¡AÀNµM¤j®©¡C¦]¬°½d¨Ò¤¤¨S¦³ªÅ¥Õªí³æ¤§¬G¡C

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD