MultiLevel BOM Comparison

Hi Experts,

I am good at excel Vlookup on single level BOM Comparison. But I need Multi Level BOM(Bill Of Materials) Compare, What I am Looking is VB Code two BOMS(OLD BOM & NEW BOM) importing automatically and compare the changes(1. What new Part number Added & where added, 2. What deleted & where deleted, 3. Any UP issues Items, 4. Any Descriptions Changes where Changed, 5. Qty Changed & Where Changed.


I checked on forums no one asked this question. Advance Thanks for solution providers.

Thanks
TTG