Problem for giving formulas in excel sheet - Excel automation with macro.

Question

0.00/5 (No votes)

See more:

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)

CSS

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

Posted 11-Aug-11 8:31am

Ajain A K

Updated 11-Aug-11 8:46am

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2012-04-12T08:34:00

Solution 1

All you need to do is record a macro of you manually doing what you want and then you can see what the code is.

Posted 12-Apr-12 8:34am

ZurdoDev