|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim fin, fin2
- If Target.Address = "$D$2" Then
- If Target = "入库单" Then
- Application.EnableEvents = False
- Call rukugongshi
- ' Range("z1") = Range("z1") + 1
- Sheets("入库单").Range("j3") = "RKD" & Format(Date, "yymm") & Format(Range("z1"), "00000")
- Application.EnableEvents = True
- Else
- Application.EnableEvents = False
- ' Range("AA1") = Range("AA1") + 1
- Sheets("入库单").Range("j3") = "RKTD" & Format(Date, "yymm") & Format(Range("AA1"), "00000")
- Sheet1.Range("b5:j14,b3:c3,c16,g16:j16").ClearContents
- Call rukugongshi
- Application.EnableEvents = True
- End If
- End If
- If Target.Row > 4 And Target.Row < 15 And Target.Column = 2 Then
- Set fin = Sheets("资料库").Range("a:a").Find(Cells(Target.Row, 2), lookat:=xlWhole)
- Set fin2 = Sheets("入库总汇").Range("f:f").Find(Cells(Target.Row, 2), lookat:=xlWhole)
- If Not fin Is Nothing Then
- Application.EnableEvents = False
- Call rukugongshi
- Cells(Target.Row, 3).Resize(1, 3) = Sheets("资料库").Range("b" & fin.Row & ":d" & fin.Row).Value
- 'Cells(Target.Row, "f").Resize(1, 2) = Sheets("资料库").Range("j" & fin.Row & ":k" & fin.Row).Value
- 'Set fin = Sheets("资料库").Range("a:a").Find(Cells(Target.Row, 2), lookat:=xlWhole)
- Application.EnableEvents = True
- Else
- MsgBox "没有找到该编号或者编码输入错误,请重新输入"
- Exit Sub
- End If
- If Not fin2 Is Nothing Then
- Application.EnableEvents = False
- 'Set fin2 = Sheets("入库总汇").Range("f:f").FindPrevious(after:=fin2)
- Cells(Target.Row, 6).Resize(, 3).Value = fin2.Offset(, 4).Resize(, 3).Value
- 'Cells(Target.Row, 6) = fin2.Offset(, 4).Value
- 'Cells(Target.Row, 7) = fin2.Offset(, 5).Value
- 'Cells(Target.Row, 8) = fin2.Offset(, 6).Value
- 'Cells(Target.Row, 6) = Sheets("入库总汇").Range("L" & fin2.Row).Value
- 'Cells(Target.Row, 7) = Sheets("入库总汇").Range("L" & fin2.Row).Value
- ' Cells(Target.Row, 6).Resize(1, 3) = Sheets("入库总汇").Range("k" & fin2.Row & ":l" & fin2.Row).Value
- Application.EnableEvents = True
- Else
- 'Application.EnableEvents = False
- 'MsgBox "没有找到该编号售价,默认为零"
- 'Cells(Target.Row, 5) = 0
- Exit Sub
- End If
- Application.EnableEvents = True
- End If
- ' Sheets("销售单").Protect 123456
- End Sub
复制代码 |
|