loop66
08-02-2019, 10:11 AM
Need help with project,i have two workbooks (over 5000 rows) need to compare same column B in both files if value is found then copy from book2 to book1 only columns C(to column N) and I(to column O) and put word OK in column M , if value is not found copy whole row in different order.
All details and samples are in attachment
Order if not found:
Column C(book2) to column N(book1)
Column D(book2) to column D(book1)
Column E(book2) to column E(book1)
Column I(book2) to column O(book1)
Column M(book2) to column C(book1)
24732
24733
24734
All details and samples are in attachment
Order if not found:
Column C(book2) to column N(book1)
Column D(book2) to column D(book1)
Column E(book2) to column E(book1)
Column I(book2) to column O(book1)
Column M(book2) to column C(book1)
24732
24733
24734