+ Reply to Thread
Results 1 to 3 of 3

Macro that compares balance totals in multiple worsheets and calculates differences?

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    NY, USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Macro that compares balance totals in multiple worsheets and calculates differences?

    This should be relatively easy for a knowledgable coder. I have a cover sheet which I report balances based on several worksheets. I would like to run a macro that can simply check the totals against the cover sheet totals to make sure the numbers match in the specified cell. That way, I avoid any human error. Can anyone suggest a simple way? Appreciate your help.

    For example, in sheet1, I have a balance total in say cell D10. D10 should match a total in sheet3 in say K7. If it doesnt match, I'd like to have the difference show in E10. The cells are arbitrary. Just looking for a general form that I can adjust according to my layout. Thank You!

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Macro that compares balance totals in multiple worsheets and calculates differences?

    A macro is not necessary

    =IF((D10=Sheet3!K7),"condition1","condition2")

    Replace "condition1" and "condition2" with the appropriate formulas
    Click on star (*) below if this helps

  3. #3
    Forum Contributor
    Join Date
    05-25-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Macro that compares balance totals in multiple worsheets and calculates differences?

    For your specific example, this is how you reference multiple sheets in excel formula (e.g. no need to "code" for this);

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Let me know if you have any questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1