I am trying to compare two Excel files. If a cell in WB1, row H3, matches a cell in WB2, B1 - I want it to display the contents in the WB2 A1 cell. It will need to loop through all of the cells in both workbooks and display results accordingly. What is the easiest way to do this?
Solved by B. S. in 17 mins