Sub 录入及修改()
Dim ar As Variant
Dim rn As Range
Dim br()
With Sheets("审批单")
ar = .Range("a1:g24")
bh = .[g3]
End With
If bh = "" Then MsgBox "请录入编号!": End
ReDim br(1 To 1, 1 To 13)
br(1, 1) = ar(3, 7)
br(1, 2) = ar(3, 2)
br(1, 3) = Sheets("sheet2").[a4]
br(1, 4) = ar(6, 5)
br(1, 5) = ar(8, 7)
br(1, 6) = ar(9, 2)
br(1, 7) = ar(10, 3)
br(1, 8) = ar(11, 3)
br(1, 9) = ar(12, 3)
br(1, 10) = ar(13, 3)
br(1, 11) = ar(14, 2)
br(1, 12) = ar(14, 7)
br(1, 13) = ar(15, 2)
With Sheets("记录")
r = .Cells(Rows.Count, 1).End(xlUp).Row + 1
Set rn = .Range("a1:a" & r).Find(bh, , , , , , 1)
If rn Is Nothing Then
x = r
ts = "录入完毕!"
Else
x = rn.Row
ts = "更新完毕!"
End If
.Cells(x, 1).Resize(1, UBound(br, 2)) = br
End With
MsgBox ts
End Sub
|