Dear All,

I am looking for help on a macro which can extract lowest level parts from the Bill of Materials that are in a folder.
I have around 1000 Bill of materials from which child parts have to be extracted, which is taking lots of time doing manually.

I don't have programming knowledge 120003515.xlsx

1. Select the folder where all the Bill of materials are placed
2. Open each Bill of material excel and identify the lowest level parts
2.1 Hierarchy will be shown as (in Explosion Level) .1, ..2, ...3, ....4 and so on
Identification of lowest level parts: Any part has its child will be the lowest
Ex: If ..2 has ..3, only ..3 parts has to be considered as lowest
If ..2 do not have ..3, ..2 will be the lowest
If ..2 has ..3 and ...3 has ....4, ....4 will be the lowest
3. Extract Only the lowest level parts to a new sheet (Child Part) in the same excel
4. Creat only the unique list in Column F & G
5. Create a single excel with only the lowest level parts

Regards,
Vijay