Wanted to extract matching data based on a cell from one workbook to another workbook when there is a match.
Normally I would get the old workbook and migrate the data to the new workbook if the part numbers match using vlookup. But I wanted to see if there is a way of doing this for each tab using VBA.
Attached is "OLD DATA" and "NEW DATA"
On the "OLD DATA" there is data starting from columns I thru r. What I wanted is that same data to go into the "NEW DATA" if the part numbers match at column A then populate with the information from the "OLD DATA" starting from columns I thru R for each tab.