- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 12# yagami12th - Option Explicit
- Dim Flag
- Dim myRow As Integer
- Dim newSheet As String
- Private Const XpasteSheet = "pick & num"
- 'Private Const "³]¬°¼Ò²Õªº¨p¥Î±`¼Æ ¨äȦp¦r±©Ò¥Ü ***«ü©w ¶K¤Wªº¤u§@ªí¦WºÙ
- Sub addsheetVer2()
- Static Num As Integer
- On Error GoTo AD:
- With Sheets(XpasteSheet)
- .Cells.Clear
- Num = Num + 1
- End With
- Exit Sub
- AD:
- Sheets.Add(after:=Sheets(Sheets.Count)).Name = XpasteSheet
- ''«ü¦W¤Þ¼Æ¡A¼Æ¸ÓexcelÀɦ³´XÓsheet©ñ¦b³Ì¥kÃä
- Resume 'ªð¦^µ{§Ç¿ù»~³B
- End Sub
- Sub ChooseVer2(rowChoose, sheetName As String) 'ì¥ý¥u¦³¿é¤J¦C¸¹¡A²{¦bn¥[¤W¤u§@ªíªº¦W¦r
- If Worksheets(sheetName).Cells(rowChoose, 5) > 10 Then Flag = 1 '¥u¿ï¨ú«ü©wsheetªº¸ê®Æ°µ¿z¿ï
- End Sub
- Sub CopyPasteVer2(rowCopy, rowPaste, copySheet As String, pasteSheet) 'copy the row rowcopy in sheet with name "2330"
- Dim myStr As String 'and paste to the row rowpaste in the sheet "pick"
- Sheets(copySheet).Select
- myStr = rowCopy & ":" & rowCopy
- Rows(myStr).Select
- Selection.Copy
- Sheets(pasteSheet).Select
- myStr = "A" & rowPaste
- Range(myStr).Select
- ActiveSheet.Paste
- End Sub
- Sub main3()
- Dim i As Integer
- Dim myRange As Range
- Dim myCell
- Dim mySheet As String
- mySheet = InputBox("input the sheet name you analyze") '¿ï¾Ü¤u§@ªí
- Set myRange = Application.InputBox("Choose the days", Type:=8)
- 'À°§Ú¿ï¨ú§Ún¿z¿ïªº½d³ò ** n¿ï¨ú¾ã¦C **
- Set myRange = myRange.SpecialCells(xlCellTypeConstants) '¿ï¨ú¾ã¦C¦³¸ê®Æªº½d³ò
- addsheetVer2 '°õ¦æ¤Wz·s¼W¤u§@ªíªºµ{¦¡¡A¨C¦¸¼W¥[ªº¤£¤@¼Ë¡A¥i¥H°õ¦æ¤W±¼gªº¦n´XӰƵ{¦¡¡A¥i¥HÅý¨CÓµ{¦¡¤À¤u¦X§@¡A²Õ¦X¦b¤@°_
- myRow = 1
- For Each myCell In myRange '¦b§Úªºmyrange¸Ì¹ï¨C¤@Ómycell¡A¨Ó°µ¤U±ªº¨Æ±¡
- i = myCell.Row
- Flag = 0 '¤£²Å¦X§Úªºn¨D´N¸õ¨ì¤U¤@°é¥h¬Ý¬O§_¦³²Å¦X
- ChooseVer2 i, mySheet 'ÀË´ú²Ä20¦æ¬O§_²Å¦X§Ú³]ªº±ø¥ó
- If Flag = 1 Then
- CopyPasteVer2 i, myRow, mySheet, XpasteSheet '¦b«ü©wªº¤u§@ªí§@¿z¿ï«á¶K¹L¥h¡A²Å¦X³]©w±ø¥ó¡A¶K¨ì·sªº¤u§@ªí¡A¦]¬°¤£¬O¥u¦³²Ä¤G¤Q¦æ¡A©Ò¥Hn¼g°j°é
- myRow = myRow + 1
- End If
- Next
- End Sub
½Æ»s¥N½X |
|