Using macro to convert single level BOM to Multi Level BOM
Hi expert, I have a BOM structure A B | | -------------------- | | | | C3 C2 C1 C4 | ------- | | D1 D2 | E1 Where A and B are different top level Finish Goods, with commo subassembly C1. I was given with a single level BOM structure as below in Excel file. Assembly Component -------- --------- A C1 A C2 A C3 B C1 B C4 C1 D1 C1 D2 D1 E1 I need to convert into the following format in Excel file: (added with new column - Top FG) Top FG Assembly Component ------ -------- ------------- A A C1 A A C2 A A C3 B B C1 B B C4 A C1 D2 B C1 D2 A D1 E1 B D1 E1 A C1 D1 B C1 D1 I am looking at a macro which can help me to add a new column showin the top level finish goods. criteria is any assembly that is not foun in component consider as top level Finish good and if a assembly exis in more than one top level finish goods a new record need to b created. Can anyone help. Thanks. Andre -- andrew_chon ----------------------------------------------------------------------- andrew_chong's Profile: http://www.excelforum.com/member.php...fo&userid=3128 View this thread: http://www.excelforum.com/showthread.php?threadid=50953 |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com