Sub 工作表合并()
x = Range("A65536").End(xlUp).Row '行数
Range("B2:AF" & x).ClearContents
For m = 2 To x
For Each st In Worksheets
If st.Name = Cells(m, 1) Then
Cells(m, 2).Resize(1, 31) = Application.Transpose(st.Range("I5:I35"))
End If
Next
Next
End Sub 每日个人产量记录表.rar(11.72 KB, 下载次数: 20)
Sub 工作表合并()
x = Range("A65536").End(xlUp).Row '行数
Range("B2:AF" & x).ClearContents
For m = 2 To x
For Each st In Worksheets
If st.Name = Cells(m, 1) Then
Cells(m, 2).Resize(1, 31) = Application.Transpose(st.Range("I5:I35"))
End If
Next
Next
End Sub 每日个人产量记录表.rar(11.72 KB, 下载次数: 20)