- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-11-20 07:38 ½s¿è
¦^´_ 3# GBKEE
¦^´_ 1# kai6929
ªº½T¬OÓÆZ¤£¿ùªº½d¨Ò¤À¨É¡A¤×¨ä¬O AdvancedFilter ¶i¶¥¿z¿ïªº¹ê°ÈÀ³¥Î¡A
¨ä²Ó¿°¦a³B²z»Pªí¹F§¡¤Q¤Àºë´ï¡AÂÔ¦¹·PÁ GBKEE ªº½u¤W«ü¾É¡C
¥Ø«e¡A§Ú±N #3 ªºµ{¦¡²¤¬°×§ï¦¨¡G¦pªG²M³æ (ComboBox) ¤º¤u§@ªí·~¤w¦s¦b¡A
«h¦A¦¸±N¥¦¶}±Ò¡A§_«h±N¤u§@ªí¡u½Ð´Ú®ÑÂú§Î¡v½Æ»s¨ì©Ò¦³¤u§@ªíªº³Ì«á¡C
¦p¦¹¡A¤~¤£P¦]«Âж}±Ò¦Ó¾ÉPªº¿ù»~¤¤Â_°õ¦æ (GBKEE ªº»yªk¬Oª½±µ¼g¤J¨ì¡u½Ð´Ú®ÑÂú§Î¡v)¡C
(#1 ªºì¥»¥Î·N¡A¥i¯à¬O·Q«O¯dì©l¥Àªí¡A¦Ó©ó¿ï³æ®É¦A¥t¦æ·s¼W¡u½Ð´Ú®Ñ¡v)- Private Sub »s§@½Ð´Ú®Ñ()
- Dim cts As Integer, existed As Boolean
-
- Application.ScreenUpdating = False
-
- existed = False
- For cts = 3 To Worksheets.Count
- If Sheets(cts).Name = myComboBox Then existed = True: Exit For
- Next cts
-
- ' ±N¤u§@ªí¡u½Ð´Ú®ÑÂú§Î¡v½Æ»s¨ì©Ò¦³¤u§@ªíªº³Ì«á
- If existed = False Then Worksheets("½Ð´Ú®ÑÂú§Î").Copy After:=Worksheets(Worksheets.Count): cts = Worksheets.Count
-
- With Sheets("¾P°â¸ê®Æ")
- .Range("A3").AutoFilter 2, myComboBox ' ¦Û°Ê¿z¿ï B Äæ myComboBox(ÅU«È)
- .Columns(2).Hidden = True ' ÁôÂÃBÄæ
- .Range("A3").CurrentRegion.Copy ' ½Æ»s¿z¿ï¥Xªº ¤é´Á,°Ó«~,³æ»ù,¼Æ¶q,ª÷ÃB
- .AutoFilterMode = False
-
- With Worksheets(cts)
- .Name = myComboBox ' ³]©w¤u§@ªí¦WºÙ
- .Range("A6") = myComboBox
- .Range("A11").CurrentRegion = "" ' ²M°£Â¦³¸ê®Æ
- .Range("A11").PasteSpecial xlPasteValuesAndNumberFormats ' ¶K¤W ȤΤ½¦¡
- End With
- Application.CutCopyMode = False ' ¨ú®ø½Æ»sªºµê½u
- .Columns(2).Hidden = False ' ¨ú®øÁôÂÃBÄæ
- End With
-
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X
¾P°âºÞ²z×¹¢ª©.rar (40.49 KB)
|
|