本帖最后由 爱疯 于 2013-3-1 11:45 编辑
Sub Macro2()
With Sheets("装箱单")
.Range("H:H").ClearContents
.Range("H2") = "实收"
.Range("H3").FormulaR1C1 = "=SUMIF(Sheet1!R2C1:R13C2,VLOOKUP(装箱单!RC[-2],Sheet1!R2C1:R13C2,1,FALSE),Sheet1!R2C2:R13C2)"
.Range("H3").AutoFill Destination:=.Range("H3:H" & .Cells(.Cells.Rows.Count, "a").End(xlUp).Row)
End With
End Sub
加个清除