|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address = "$B$1" Then
- Range("a1").CurrentRegion.Offset(1, 0).Clear
- zf = Target.Value: s = 1
- For i = 2 To 3
- arr = Sheets(i).Range("a1").CurrentRegion
- For j = 3 To UBound(arr)
- If arr(j, 2) Like "*" & zf & "*" Then
- s = s + 1
- Sheets(i).Cells(j, 1).Resize(1, UBound(arr, 2)).Copy Cells(s, 1)
- End If
- Next
- Next
- End If
- End Sub
复制代码 |
|