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.
Bookmarks