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