|
发表于 2011-8-16 16:58
|
显示全部楼层
本楼为最佳答案
回复 wetz123 的帖子
- Sub 添加公式()
- ROW1 = Sheets("SHEET1").Range("A65536").End(xlUp).Row
- For i = 3 To ROW1
- Range("G" & i).FormulaR1C1 = _
- "=IF(LEN(RC2)>0,VLOOKUP(RC2,[我的进销存模板1]进货表!R1C[-5]:R65536C[1],2,0),"""")"
- Range("H" & i).FormulaR1C1 = _
- "=IF(LEN(RC2)>0,VLOOKUP(RC2,[我的进销存模板1]进货表!R1C[-6]:R65536C,4,0),"""")"
- Range("I" & i).FormulaR1C1 = _
- "=IF(LEN(RC2)>0,VLOOKUP(RC2,[我的进销存模板1]进销存统计!R1C[-7]:R65536C[-1],7,0),"""")"
- Range("J" & i).FormulaR1C1 = "=IF(RC[-8]>0,RC[-7]*RC[-6],"""")"
- Next i
- End Sub
复制代码
|
|