Ilogic for changing partno from a excel

[Anonymous]

I Was looking for a ilogic code which can help in changing some of the part numbers in an assembly as per the excel sheet, For Example : We have an assembly with 35 Components and 5 Sub assemblies  - I need to check the part no's with 1st column in the excel - if exists then i need to change the number to the 2nd Column as per the excel file attached. 

[johnsonshiue]

Hi! Certainly this can be done programmatically or iLogic. But, it can also be done manually without too many clicks. Simply open the assembly and go to BOM table. Sort by certain property. You can actually copy from Excel cells and paste them directly to BOM Part Number column.

Many thanks!

[Anonymous]

Actually the same list in the excel needs to be done for around  60 - Assemblies - Which will take more time to open and do that to each BOM