Sub justtest() Dim arr, dic, i&, arrt() Set dic = CreateObject("scripting.dictionary") arr = Sheet2.Cells(1, 3).CurrentRegion.Value For i = 2 To UBound(arr, 1) dic.Add arr(i, 1), i Next arr = [d80:aa80] With Sheet2.Cells(dic([c80].Value), 4).Resize(1, UBound(arr, 2)) .ClearContents .Value = arr End With Set dic = Nothing End Sub
Sub justtest() Dim arr, dic, i&, arrt() Set dic = CreateObject("scripting.dictionary") arr = Sheet2.Cells(1, 3).CurrentRegion.Value For i = 2 To UBound(arr, 1) dic.Add arr(i, 1), i Next arr = [d80:aa80] With Sheet2.Cells(dic([c80].Value), 4).Resize(1, UBound(arr, 2)) .ClearContents .Value = arr End With Set dic = Nothing End Sub