I have an excel ( "book1") file which has a column ("keyword") with a word in each cell and a blank column "details". I have another excel file ( "book2) which has the same two columns : (1) "keyword"; which has the same words as book 1 but not in the same sequence; (2) "details": which has some text. i need a macro which automatically copies the text from "details" col in book2 to the empty "details" col in book1 based on matching words in the "keyword " columns of the two excel files. See attached: Since i cant upload two files, iam uploading one with two excel sheets representing two diff excel files. Thanks, Shash
Solved by O. U. in 25 mins