|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim arr, brr(1 To 1000, 1 To 27), crr(1 To 1, 1 To 27)
- Dim ws As Worksheet
- With Worksheets("查询")
- .[a7:ak100].ClearContents
- End With
- For Each ws In Worksheets
- If ws.Name <> "查询" Then
- With ws
- n = 0
- rw = .[c65536].End(3).Row
- arr = .Range("c3:ak" & rw)
- For i = 1 To UBound(arr)
- n = n + 1
- brr(n, 1) = ws.Name
- brr(n, 2) = arr(i, 1)
- For j = 11 To UBound(arr, 2)
- brr(n, j - 8) = arr(i, j)
- Next
- Next
- End With
- With Worksheets("查询")
- For x = 1 To UBound(brr)
- If Cells(4, "i") = brr(x, 2) Then
- For y = 1 To 27
- crr(1, y) = brr(x, y)
- Next
- End If
- Next
- End With
- End If
- Worksheets("查询").[j65536].End(3).Offset(1, 0).Resize(1, 27) = crr
- Erase crr
- Next
- End Sub
复制代码 |
|