+ Reply to Thread
Results 1 to 2 of 2

VBA or Excel formulas to calculate cells in two separate sheets

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Birmigham, UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    VBA or Excel formulas to calculate cells in two separate sheets

    Hi All,

    I have these data with two separate sheets in which each one is the same size, 144 cells and 214 rows. I would like to create a VBA or excel fonction to calculate the difference between the crosponding cells in each sheet. Is it possible to do it with fuctions?

    Regards,

    Malowle

  2. #2
    Forum Contributor
    Join Date
    09-11-2009
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    102

    Re: VBA or Excel formulas to calculate cells in two separate sheets

    hi,
    if each sheet is the same size, you can use function "And" or "If" to compare two sheets.

+ 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