Hello,
I am interested in taking this project of yours.
Besides Excel and VBA, I actually have experience with BOM. I have worked a couple years in a Maintenance Department and have developed one spreadsheet for mechanical and electrical spare parts, besides developing another one for the whole manufacturing plant.
If you want to discuss the project in the detail, please send me a message.
Best Regards,
Gustavo Alvarenga