Sub cc()
Dim str$, c As Range, rng As Range
str = InputBox("请输入查找文本", "查找")
Set c = Sheet1.Range("a:a").Find(str)
If Not c Is Nothing Then
Set rng = c.CurrentRegion
rng.Offset(1, 0).Resize(rng.Rows.Count - 1, rng.Columns.Count).Select
Selection.Copy
End If
Set rng = Nothing
Set c = Nothing
End Sub
追问老师现在我想,根据sheet2中B列项目名称的顺序,重新对表一进行排序,希望老师帮忙
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cc7d3ef858113632762d0c3b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)