5,139
社区成员
发帖
与我相关
我的任务
分享
Sub 复制()
With Application.WorksheetFunction
Sheets("sheet1").Range("A" & .Match("20070102", Sheets("sheet1").[A:A], 0) & ":C" & .Match("20070103", Sheets("sheet1").[A:A], 0) + .CountIf(Sheets("sheet1").[A:A], "20070103") - 1).Copy (Sheets("sheet2").[A2])
End With
End Sub
Dim iRowIndex As Integer
Dim strID As String
Dim strYear As String
iRowIndex = 1
Do While 1
strID = Sheet1.Range("A" & iRowIndex).Value
If strID = "" Then
Exit Sub
End If
If strID="20070102 " or strID="20070103" Then '具体匹配项可当参数传入
Sheet2.Range("A" & iRowIndex).value = Sheet1.Range("A" & iRowIndex).value
Sheet2.Range("B" & iRowIndex).value = Sheet1.Range("B" & iRowIndex).value
Sheet2.Range("C" & iRowIndex).value = Sheet1.Range("C" & iRowIndex).value
End If
iRowIndex = iRowIndex + 1
Loop
Sub copyData()
Dim i As Integer
Dim j As Integer
j = 1
For i = 1 To 200
If Sheet1.Range("A" & i) = "20070102" Then
Sheet2.Range("A" & j) = Sheet1.Range("A" & i)
Sheet2.Range("B" & j) = Sheet1.Range("B" & i)
Sheet2.Range("C" & j) = Sheet1.Range("C" & i)
j = j + 1
End If
Next i
End Sub