excel 中,要把同类型物品的所有码数,数量分别合并,求和起来,应该怎么做呢
VBA代码如下,详见附件!Subtest()DimdAsObject,d1AsObject,Ary,mStrAsStringAry=Range("A1").CurrentRegionSetd=CreateObject("scripting.dictionary")Setd1=CreateObject("scripting.dictionary")Range("E:G")=""Range("E1:G1")=[{"商品编码","尺码","实盘数量"}]Fori=2ToU···