Private Sub CommandButton1_Click()
Sheet5.Range("A4:K10000").Clear '清除之前所有的筛选结果
ends = Sheet1.Range("B65536").End(xlUp).Row '动态找到B列的最后一个单元格
For Each Rng In Sheet1.Range("B2:B" & ends)
m = m + 1
If Rng Like Sheet5.Range("B1").Value & "*" Then '如果条件成立,那么
k = k + 1
Sheet1.Range("A" & m + 1 & ":K" & m + 1).Copy Sheet5.Range("a" & k + 3) '将记录复制到另一个区域
End If
Next
End Sub