Match and extract column info from 2 workbooks

[IKHAN]

Hi
I have 2 workbooks ... Master.xls (Sheet "Test1") and Info.xls (Sheet "Test2")

Macro reqd. to match "Column B" in Master.xls (Sheet "Test1") with "Column B" Info.xls (Sheet "Test2")

if matched found between 2 workbooks Then copy "Column E" Info.xls (Sheet "Test2") INTO blanks "Column H" Master.xls (sheet "Test1")

And second criteria if any mismatch found between Master.xls (sheet Test1) "Column B and H" and "Column B and E" Info.xls (Sheet "Test2") must fill color "RED" in "Column B" Master.xls (Sheet "Test1").

Really appreciate assistance....

 

[Marc L]

Hi !

Use a loop on blanks of Master column H
and just with an easy VLOOKUP between worksheets :
if result is an error so mod formatting and if not
just copy the result in column H …
​