|
- Sub Macro1()
- Dim arr, brr, d, i&, n&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- Sheet3.Activate
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2)
- Next
- Application.ScreenUpdating = False
- For i = 2 To UBound(brr) - 1 Step 2
- [d2] = brr(i, 3)
- [d3] = brr(i, 2)
- [d4] = brr(i, 5)
- [d5] = d(brr(i, 5))
- [d6] = brr(i, 4)
- [i2] = brr(i + 1, 3)
- [i3] = brr(i + 1, 2)
- [i4] = brr(i + 1, 5)
- [i5] = d(brr(i + 1, 5))
- [i6] = brr(i + 1, 4)
- n = Range("c65536").End(xlUp).Row + 3
- [a1:i6].Copy Cells(n, 1)
- For j = 1 To 6
- Cells(n + j - 1, 1).RowHeight = Cells(j, 1).RowHeight
- Next
- Next
- [a1:i8].Delete Shift:=xlUp
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|