|
本帖最后由 cpl275538 于 2017-7-20 09:59 编辑
1、当B列和J列选择好产品名称后,自动填出相应编号,也就是VLOOKUP功能。
2、编号需要自动填入,不需要点击执行代码
3、求G列和O列代码
感谢!
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Intersect(Target, [b3:b70]) Is Nothing And Intersect(Target, [j3:j70]) Is Nothing Then Exit Sub
- Dim rng As Range, sh&
- If Target.Column = 2 Then sh = 2 Else sh = 3
- Target.Offset(, 1).Resize(, 4).Validation.Delete
- Target.Offset(, 1).Resize(, 4).ClearContents
- Set rng = Sheets(sh).UsedRange.Find(Target, lookat:=xlWhole)
- If Not rng Is Nothing Then Target.Offset(, 5) = rng.Offset(, 4)
- End Sub
复制代码
|
|