|
- Sub Macro1()
- Dim arr, rng As Range, n&, i&
- arr = Sheet2.[b3:c5]
- Sheet1.Activate
- [a2:g2].Copy Sheet3.[a2]
- For i = 1 To UBound(arr)
- Set rng = Columns(3).Find(arr(i, 1))
- n = Sheet3.Range("a65536").End(xlUp).Row + 1
- If Not rng Is Nothing Then Cells(rng.Row, 1).Resize(arr(i, 2), 7).Copy Sheet3.Cells(n, 1)
- Next
- Sheet3.Activate
- End Sub
复制代码 |
|