|
Public Sub eer()
Dim arr(), x As Range, n
With Sheets("源数据")
For Each x In .Range(.Cells(7, 4), .Cells(.[a65536].End(xlUp).Row, .UsedRange.Columns.Count))
n = n + 1
ReDim Preserve arr(1 To 4, 1 To n)
arr(1, n) = .Cells(x.Row, 1).Value
arr(2, n) = .Cells(x.Row, 2).Value
arr(3, n) = .Cells(x.Row, 3).Value
arr(4, n) = IIf(x.Value = 1, .Cells(6, x.Column).Value, "")
Next x
End With
Sheets.Add after:=Sheets(Sheets.Count)
[a1:d1] = Array("姓名", "性别", "时间1", "时间2")
[a2].Resize(n, 4) = Application.Transpose(arr)
End Sub |
|