- Sub Macro1()
- Dim arr, brr(1 To 1, 1 To 6), n&, rng As Range
- arr = [a1:j15]
- brr(1, 1) = arr(5, 7)
- brr(1, 2) = arr(10, 3)
- brr(1, 3) = arr(11, 2)
- brr(1, 4) = arr(11, 5)
- brr(1, 5) = arr(8, 2)
- brr(1, 6) = DateSerial(arr(15, 5), arr(15, 7), arr(15, 9))
- With Sheet2
- Set rng = .Columns(1).Find(arr(5, 7), lookat:=xlWhole)
- If rng Is Nothing Then
- n = .Range("a65536").End(xlUp).Row + 1
- .Cells(n, 1).Resize(1, 6) = brr
- End If
- End With
- End Sub
复制代码 |