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

¤u§@ªí¦P¨B¼W¥[¸ê®Æ

¤j®a³o»ò¨º»ò±j³á~~~~~~~

TOP

¦^´_ 32# Leo1318
  1. Option Explicit
  2. Sub ¥¨¶°1()
  3. Sheets("Sheet1").Columns("A:B").AdvancedFilter Action:=xlFilterCopy, _
  4.         CopyToRange:=Range("A1"), Unique:=False
  5. End Sub
½Æ»s¥N½X

TOP

¦^´_ 33# HUNGCHILIN

ÁÂÁª©¥D, ¦ýÁÙ¤£¤Ó¤F¸Ñ, VBA¸Ìªº»y¨O, §¹¥þ¨S¦³SHEET 2ªº¦r²´. ¨ºµ{¦¡¬O¦p¦ó¥i¥H§âSHEET 1ªº¤å¦r¥[¨ìSHEET 2¸Ì????

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD