|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- On Error Resume Next
- If Range("b2") <> "" And Target.Address(0, 0) = "B2" Then
- Dim a As Integer, b, i As Integer, j As Integer
- b = Range("b2").Value
- a = Application.WorksheetFunction.CountIf(Sheet1.Range("p:p"), b)
- If a = 0 Then
- MsgBox "无此项"
- End
- End If
- Range("A4:L100").ClearContents
-
- For i = 1 To a
- For j = 1 To Range("A3").End(xlToRight).Column
- Range("A4").Offset(i - 1, j - 1) = Sheet1.Range("A1").Offset(i, Application.WorksheetFunction.Match(Range("A3").Offset(0, j - 1).Value, Sheet1.Range("A1:Q1"), 0))
- Next
- Next
- MsgBox "已更新"
- End If
- End Sub
复制代码 有2个地方不严谨,2个表格的命名不一样,已经标记并修改
|
|