|
那就更加简单了,可以用公式就很简单的解决了。
汇总表的B2单元格输入公式: =XLOOKUP($A2&SUBSTITUTE(B$1,"型号","产品",1),明细表!$A:$A&明细表!$B:$B,明细表!$B:$B,"")
或者VBA代码:
- Sub demo()
- Dim i As Integer, j As Integer, k As Integer, arr, brr
- arr = Sheet1.Range("a2:a" & Sheet1.Cells(Rows.Count, 1).End(xlUp).Row)
- brr = Sheet2.Range("a2:b" & Sheet2.Cells(Rows.Count, 1).End(xlUp).Row)
- ReDim crr(1 To UBound(arr), 1 To 9)
- For i = 1 To UBound(arr)
- For j = 1 To 9
- For k = 1 To UBound(brr)
- If arr(i, 1) = brr(k, 1) And brr(k, 2) = "产品" & j Then
- crr(i, j) = brr(k, 2)
- Exit For
- End If
- Next k
- Next j
- Next i
- Sheet1.Range("b2").Resize(UBound(crr), UBound(crr, 2)) = crr
- End Sub
复制代码
|
|