|
3学分
本帖最后由 PolarisBeimin 于 2020-5-25 13:50 编辑
图中的j一直不增加,一直j=2,不知道各位有什么解决方法,我是刚入门的小白,麻烦各位前辈可以直接写一下代码,谢谢了
以下是代码原文
Sub 自动生成()
Application.ScreenUpdating = False
Dim i, j As Integer
For j = 2 To 22
For i = 2 To 22
If Sheet2.Cells(i, 1) = "" Then
Sheet2.Cells(i, 1) = Sheet1.Cells(j, 1)
End If
If Sheet2.Cells(i, 2) = "" Then
Sheet2.Cells(i, 2) = Sheet1.Cells(j, 2)
End If
If Sheet2.Cells(i, 3) = "" Then
Sheet2.Cells(i, 3) = Sheet1.Cells(j, 3)
End If
Next
Next
Application.ScreenUpdating = True
End Sub
|
最佳答案
查看完整内容
那就改成:
For i = 2 To 11
If Not IsEmpty(Sheet1.Cells(i, 1)) Then
Sheet2.Cells([a2].End(4).Row + 1, 1) = Sheet1.Cells(i, 1)
Sheet2.Cells([a2].End(4).Row, 2) = Sheet1.Cells(i, 2)
Sheet2.Cells([a2].End(4).Row, 3) = Sheet1.Cells(i, 3)
End If
Next
还是不能判断是否重复,多按一次就多写一天;
如果你 ...
|