|
Sub 按钮1_Click()
If Len([b1]) <> 4 Then
MsgBox "b1单元格数据不符合要求"
Exit Sub
End If
ActiveSheet.UsedRange.Offset(2).ClearContents
arr = Sheets("原始数据").UsedRange
r = 0
For j = 2 To UBound(arr)
If Right(arr(j, 5), 4) = [b1] & "" Then
r = r + 1
For i = 1 To UBound(arr, 2)
arr(r, i) = arr(j, i)
Next i
End If
Next j
If r > 0 Then
r1 = 0
If VBA.IsDate([d1]) Then
For i = 1 To r
If CDate([d1]) = CDate(arr(i, 6)) Then
r1 = r1 + 1
For j = 1 To UBound(arr, 2)
arr(r1, j) = arr(i, j)
Next j
End If
Next i
If r1 > 0 Then
[a3].Resize(r1, 6) = arr
End If
Else
[a3].Resize(r, 6) = arr
End If
End If
End Sub
Sub 按钮2_Click()
Set d = CreateObject("scripting.dictionary")
arr = Sheets("原始数据").UsedRange
Application.ScreenUpdating = False
For j = 3 To Cells(Rows.Count, 5).End(3).Row
d(Cells(j, 5) & CDate(Cells(j, 6))) = ""
Next j
For j = 2 To UBound(arr)
If d.exists(arr(j, 5) & CDate(arr(j, 6))) Then arr(j, 7) = "已标注"
Next j
Sheets("原始数据").UsedRange = arr
Application.ScreenUpdating = True
End Sub |
|