在Excel工作表中提供公式的问题-带宏的Excel自动化. [英] Problem for giving formulas in excel sheet - Excel automation with macro.
问题描述
我正在使用宏进行Excel(MS-Excel 2007)自动化,我想在一个单元格中添加一个公式.我的工作簿包含3张纸,我在第3张纸的单元格中写的公式,是指从前两张纸的值中提取结果值.我已经将公式直接赋予了"fx"区域,但它显示了一些错误或卡住的问题,因此我尝试了数据合并"选项(用于使前两张纸对第三张纸的引用),但我很怀疑在我正在做的事情上是正确的!而且我在合并选项中遇到了数据参考问题.请帮助我解决此问题.
请注意要放入单元格中的公式.
I am doing excel( MS-Excel 2007 ) automation using macro,I want to add one formula in one cell. My workbook contains 3 sheets, the formula I am writing in the cell of 3rd sheet, I mean the result value is extracted from values from first two sheets. I have given the formula stright to the ''fx'' area but it shows some error or stuck up problem so I tried with Data consolidate option ( for making the first two sheet''s reference to the 3rd sheet ) but I am doutful on what I am doing is right!! and I am facing data reference issues in consolidation option. Please help me to solve this issue.
Note the formula that I want to put into the cell.
=SUMIFS(Jr_Weekly_Status_report_9220!$K:$K,Jr_Weekly_Status_report_9220!$C:$C,
Sum!$C$2,Jr_Weekly_Status_report_9220!$L:$L,Sum!D$1,
Jr_Weekly_Status_report_9220!$J:$J,Sum!$B$1)
Sheet Names in the work book :
----------------------
Sheet 1 : Jr_Weekly_Status_report_9220
Sheet 2: NumberSheet
sheet 3 : Sum
This formula I am putting in this cell of sheet-3 : Sum
推荐答案
K:
K,Jr_Weekly_Status_report_9220!
K,Jr_Weekly_Status_report_9220!
C:
这篇关于在Excel工作表中提供公式的问题-带宏的Excel自动化.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!