New Part Numbers

[chipsguy]

Hello.
I have an excel file with 4,000+ part numbers. My Heaquarters just gave me all new part numbers for these 4000 items.

I now have 2 spreadhseets:
1 with old part numbers, description etc
1 with new part numbers, description, etc

Example:
OLD: 123456 Flat Cut
NEW: abcdef Fine Cut

part number is 1 column description is another column.
I need to replace the old with the new.

What is the easiest way to replace the old part numbers with the new ones? I cannot do an upload of only new because I want the descriptions to match and I have over 5000 additional (not affected) part numbers.

I appreciate the feedback.

 

[alansidman]

In your example, I see no correlation between the old and new. You will need to have a common field to match these in Excel. Without that, you will only be able to do this manually. In your example, how would one know that these match?

 

[mackc557]

As mentioned previously, if you do not have any form of common data (ie. Item ID or Description), then you will likely have to do things manually. HOWEVER, if you can get the old part numbers linked up correctly on the new parts sheet that was provided to you, you can run a macro to find the old number on the master list, then replace the description if needed, as well as replacing the old number with the new number.

 

[chipsguy]

Thank you. I do believe I have a link. Here is what I have:

I need to somehow put the "new" part and "new" description in place of the old reference. Then upload these 5000 parts into my ERP.

I tried Vlookup and Index but I am not sure what is happening. Does this help at all?

 

[alansidman]

You can do this with Power Query by running a Join on the common fields. If you need Mcode example then provide sample file (8-12 records) in XL2BB as we cannot manipulate pictures. Show us the old file example that needs updating and the applicable records you have shown above in XL2BB that matches the sample.