Hi, all
Can you please tell me the simplest way to solve my challenge:
I have 2 sheets (let say named "OLD", "NEW", Excel 2010) in following format (both are same):
Col.1 Col.2 Col.3
ID Description Price
I want to replace Column 3 (Price) value from "NEW" to Column 3 in "OLD".
I can not use sorting, because "OLD" is structured in a bit different way (has extra rows, such as explanations, additional information, etc).
So order of rows in NEW is different than in OLD. For example row 1 in OLD may be row 425 in NEW. Basiclly it is to match ID, which i same in OLD and NEW and then write corresponding Price value from NEW to OLD. What is the simplest way to do it?
Can it be done with array of inbuilt functions or macro is needed?
Thank you in advance. Marko
Bookmarks