打开VBE编辑器,代码放到资料表中- Private Sub Worksheet_Change(ByVal Target As Range)
- Application.EnableEvents = False
- Range("B4:D4,B5,D5").ClearContents
- Range("B4") = [IF(D1>0,VLOOKUP(D1,数据源!A:G,2,),"")]
- Range("B5") = [IF(D1>0,VLOOKUP(D1,数据源!A:G,3,),"")]
- Range("D5") = [IF(D1>0,VLOOKUP(D1,数据源!A:G,4,),"")]
- Application.EnableEvents = True
- End Sub
复制代码 |