|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Target = "" Then Exit Sub
- If Target.Address <> "$C$3" Then Exit Sub
- Dim bj$, r1, Arr, col%, c%, m&, i&
- bj = Target.Value
- Set r1 = Sheet3.[c17:c500].Find(bj, , , 1)
- [g3] = Sheet3.Cells(r1.Row, 4).Value
- Arr = Sheet3.[a1].CurrentRegion
- Set r1 = Sheet3.Rows(3).Find(bj, , , 1)
- col = r1.Column: c = 2
- For j = col To UBound(Arr, 2) Step 13
- c = c + 1: m = 5
- For i = 4 To UBound(Arr) Step 2
- Cells(m, c) = Arr(i, j)
- Cells(m + 1, c) = Arr(i + 1, j)
- m = m + 3
- Next
- Next
- End Sub
复制代码 |
|