column comparison issue between two workbooks

[klpw]

Hi guys,

I want to compare column between 2 workbooks. If the data from column D in fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If they are not matched, then data from column A to C in fortest.xlsx needs to be copied and pasted to column C to E in tested.xlsm. I've created the code and it runs without error but it doesn't generate any result at all.

Thanks in advanced.

 

[Nebu]

Duplicate post
http://forum.chandoo.org/threads/need-help-with-macro.27527/#post-164856