|
请大神们看附件
- Sub 录入数据()
- Application.ScreenUpdating = False
- Dim Y
- Y = Range("H4")
- x = 1
- Do While Not (IsEmpty(Sheets(Y).Cells(x, 2).Value))
- x = x + 1
- Loop
- n = x
- z = 5
- With Sheets("单据录入")
- Do While Not (IsEmpty(.Cells(z, 2).Value))
- z = z + 1
- Loop
- For k = 5 To z - 1
- Sheets(Y).Cells(x, 1) = .Cells(2, 5)
- Sheets(Y).Cells(x, 2) = .Cells(2, 3)
- Sheets(Y).Cells(x, 3) = .Cells(k, 2)
- Sheets(Y).Cells(x, 4) = .Cells(k, 3)
- Sheets(Y).Cells(x, 5) = .Cells(k, 4)
- Sheets(Y).Cells(x, 6) = .Cells(k, 5)
- x = x + 1
- Next k
- End With
- m = x - n
- MsgBox "您已向" & Y & "中加入了" & m & "条记录,请在" & Y & "中进行确认!"
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|