|
发表于 2012-3-11 16:26
|
显示全部楼层
本楼为最佳答案
心灵有约 发表于 2012-3-11 16:03
不好意思,计算表中有误,产品编码应为乙 不是甲
其实,当计算表中原物料编码不含混合字样时,引用单价不 ... - Sub 引用单价()
- Dim ar, br, cr, dr()
- Dim i As Integer, j As Integer, k As Integer
- ar = Sheets("成本计算").Range("a1").CurrentRegion
- br = Sheets("单价").Range("a1").CurrentRegion
- cr = Sheets("单价").Range("e1:p1")
- ReDim dr(1 To UBound(ar) - 1, 1 To 1)
- For i = 2 To UBound(ar)
- For j = 2 To UBound(br)
- If (ar(i, 5) = br(j, 1) And Not ar(i, 5) Like "*混合*") Or (ar(i, 5) = br(j, 1) And ar(i, 3) = br(j, 3) And ar(i, 5) Like "*混合*") Then
- k = Application.Match(ar(i, 1), cr, 0)
- dr(i - 1, 1) = br(j, k + 4)
- Exit For
- End If
- dr(i - 1, 1) = "未找到"
- Next
- Next
- With Sheets("成本计算")
- .Range("i2").Resize(UBound(dr)).ClearContents
- .Range("i2").Resize(UBound(dr)) = dr
- End With
- End Sub
复制代码
|
|