|
Sub test()
Dim A(1 To 1000, 1 To 3), x, i
Application.ScreenUpdating = False
Sheets(1).Select
For Each x In [c4:p31]
If Len(x) Then
i = i + 1
A(i, 1) = Cells(3, x.Column)
A(i, 2) = Cells(x.Row, 1)
A(i, 3) = x
End If
Next
Sheets(3).Select
[a2:c65536] = ""
Range("A2").Resize(i, 3) = A
End Sub
考勤(虚)2.rar
(24.89 KB, 下载次数: 1)
|
|