|
本帖最后由 zjdh 于 2017-5-24 10:20 编辑
帮你修改了一下:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Target <> "" Then
If Target.Row > 3 And Target.Row < 201 Then
x = Target.Row()
With Worksheets("库存")
xfind1 = .Range("A:A").Find(Cells(x, 1), LookIn:=xlValues, After:=.[A9999], lookat:=xlWhole).Row
xfind2 = .Range(.Cells(xfind1 - 1, 2), .Cells(xfind1 + 300, 2)).Find(Cells(x, 2), LookIn:=xlValues, lookat:=xlWhole).Row
xfind = .Range(.Cells(xfind2 - 1, 3), .Cells(xfind2 + 100, 3)).Find(Cells(x, 3), LookIn:=xlValues, lookat:=xlWhole).Row
blank = .Cells(xfind, 3).End(2).Column + 1
Target.Copy .Cells(xfind, blank)
End With
End If
End If
End Sub
|
|