Results 1 to 2 of 2

Excel 2007 : Data calculations between three sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Data calculations between three sheets

    Hello everyone,
    Please is this possible (see attached file):
    I want to compare column in three sheet (as showed), for start we will compare column B in sheet 1 and column B in sheet 2 and column A in sheet 3, if be found same combination of numbers and characters in sheet 2 column B and sheet 3 column like combination in column B sheet 1 (colored fields) is no matter how much time, then doing next operation, add numbers from column “C “ sheet 2 (only left side from nonnumeric character “x”) into columns “I” and “J” inside sheet 1 and after that subtract numbers from column “B” sheet 3 (if same combination in column A founded like combination in column “B” sheet 1).Data in sheet 1 are constant where data in sheets 2 and 3 should be daily saved (recorded from other documents),first data in sheet 2 and data in sheet 3.
    I hope that will be possible and me was not to complicate when try explain, we will talk for any additional information.
    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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