|
不知为什么无法上传附件。现上传附件。
在工作表中写入下面代码:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Column = 2 And Target.Row >= 3 Or Target.Column = 3 And Target.Row >= 3 Then
Call lqxs
End If
End Sub
插入模块写入下面代码:
Sub lqxs()
Dim Arr, i&, Brr, d
Set d = CreateObject("Scripting.Dictionary")
Arr = Sheets("基础数据").[a1].CurrentRegion
For j = 4 To 44
For i = 2 To UBound(Arr)
x = Arr(i, 2) & "|" & Arr(i, 3)
d(x) = Arr(i, j)
Next
Brr = [a1].CurrentRegion
For i = 3 To UBound(Brr)
x = Brr(i, 2) & "|" & Brr(i, 3)
If d.exists(x) Then Cells(i, j) = d(x)
Next
Next
End Sub
|
评分
-
1
查看全部评分
-
|