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

¸ó¤u§@ªí¿z¿ï

¸ó¤u§@ªí¿z¿ï

¥»©«³Ì«á¥Ñ hungrn ©ó 2020-5-20 13:17 ½s¿è

¦U¦ì¥ý¶i¦n

¤u§@ªí¤@ªº¸ê®Æ­n¿z¿ï¦Ü¤u§@ªí¤G...¦pªG¥Î¥H¤Urange«ü©w½d³ò¤è¦¡¥i¥H
Sheets("sheet1").Range("A1:H250").Sheets("sheet1").Range("A1:H250").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range("A1:H1"), Unique:=False
¦]¬°¤u§@ªí¤@ªº¤º®e·|ÀHµÛ¸ê®Æªº¼W´î¦Ó§ïÅÜ row ,©Ò¥H·Q¥Î cells ¤è¦¡«ü©w½d³ò..¦ý·|Åã¥Üª«¥ó©w¸q¿ù»~..¬OAdvancedFilter  ¤£¯à¥Îcells ÁÙ¬O?
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range(Cells(1, 1), Cells(1, 8)), Unique:=False

³Â·Ð¦U¦ì¥ý¶i«ü¾É..·PÁÂ

Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Cells(1, 1), Unique:=False

§ï¦¨¥H¤W¤è¦¡§Y¥i..

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2020-5-21 00:46 ½s¿è
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRang ...
hungrn µoªí©ó 2020-5-20 14:19

§ï¦¨³o¼Ë¤]¥i¥H :
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range(Sheets("sheet2").Cells(1, 1), Sheets("sheet2").Cells(1, 8)), Unique:=False
°ÝÃDÃöÁäÀ³¬O¥ÎCells§Î¦¡¨Óªí¥Ü "½d³ò" ­n¦U§O¸Ô²Ó«ü©w¦Ó¤£¬Oµ¹°Ñ¦Ò¦ì§}(¥uµ¹ Cells(1,1) ³oºØ, «e­±¨S¦³§i¶D¥¦©ñ¦b­þ­Ó Sheet),
¦Ü©ó Sheets("sheet1").Range("A1:H1") ³oºØªí¥Ü§Î¦¡,¥»¨­´N¤w¤º§t«e«á³£¥Î³o­ÓSheet¤F,
§Aªº¤è¦¡¬O­Ó§¹¾ãªºÀx¦s®æªí¥Ü¤è¦¡(Sheet.Range).

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD