|
Sub test()
brr = Array("工作简历", "离退休信息", "参保信息")
arr = Sheets("数据").[a1].CurrentRegion
Application.ScreenUpdating = False
For j = 2 To UBound(arr)
If Len(arr(j, 1)) > 0 Then
Sheets("数据").Cells(j, 1).Resize(1, 7).Copy Sheets(brr(0)).[a2]
Sheets("数据").Cells(j, 8).Resize(1, 21).Copy Sheets(brr(1)).[a2]
Sheets("数据").Cells(j, "ab").Resize(1, 4).Copy Sheets(brr(2)).[a2]
Sheets(brr).Copy
ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & arr(j, 3) & arr(j, 10) & ".xlsx"
ActiveWorkbook.Close False
End If
Next j
Application.ScreenUpdating = True
End Sub
|
评分
-
3
查看全部评分
-
|