I need to pull data from one workbook and compare with data on another workbook and replace data if necessary. For example column I (qty) on sheet 1 from workbook 2 would be compared with column I (qty) on sheet 1 from workbook 1. The part I am having difficulty with is that the data is specific to the UPC codes (in different columns in each workbook). How do I ensure that the correct qty stay with the correct UPC codes
Solved by F. W. in 13 mins