|
发表于 2014-9-19 11:42
|
显示全部楼层
本楼为最佳答案
刚才代码没考虑保洁剂的要求,用现代码。。。。。。- Sub tt()
- arr = Sheet2.Range("a1:ap34")
- Set d = CreateObject("scripting.dictionary")
- xstr = "保潔劑殺菌劑清洗劑除垢劑鹹類"
- For i = 4 To UBound(arr)
- xm = arr(i, 1) '项目
- If InStr(xstr, xm) > 0 Then xm = "保潔劑"
- For j = 6 To UBound(arr, 2) Step 3
- zl = arr(1, j - 2) '纸类
- d(xm & zl) = d(xm & zl) + arr(i, j) '项目+纸类为key,目标成本为item
- Next
- Next
- arr = Sheet1.Range("a1:ex41")
- For i = 12 To UBound(arr)
- xm = arr(i, 2)
- If InStr(xm, "成本") = 0 Then '不含成本行
- For j = 81 To UBound(arr, 2) Step 4
- zl = arr(4, j - 2) '纸类
- arr(i, j) = d(xm & zl)
- Next
- End If
- Next
- Sheet1.Range("a1:ex41") = arr
- End Sub
复制代码 |
|