Wanted to extract matching data based on a cell from one workbook to another workbook when there is a match.
On the New Data there is code to migrate the data but for some reason the data is not matching up...these are highlighted in yellow in the New data file. Those in yellow should be identical to the Old data that is being migrated from.
On column A, row 37 for example part number 100-109 on the New Data file should be exactly the same as 100-109 from the Old data when there is a match.
It appears that when the New Data file changes....meaning part numbers in column A get either deleted or added it no longer matches up when migrating the data.