Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$J$5" Then Dim arr1, arr2, i&, dic Set dic = CreateObject("scripting.dictionary") With Sheet2 k = .Cells(.Rows.Count, "d").End(3).Row arr1 = .Cells(1, "d").Resize(k, 1).Value arr2 = .Cells(1, "N").Resize(k, 7).Value End With For i = 2 To UBound(arr1, 1) dic(arr1(i, 1)) = i Next [e10:k10].ClearContents If dic.exists([j5].Value) Then [e10:k10] = Application.Index(arr2, dic([j5].Value), 0) End If Set dic = Nothing End If End Sub
eIN3kRhV.rar
(11.37 KB, 下载次数: 45)
|