mbrooks1009
New Member
- Joined
- Feb 11, 2025
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello Everyone,
I am trying to make a BOM template. In one tab I have a part selector list which includes Part number in A16, part description in B16 and quantity in J16, Then I have 7 columns each with a different line( our projects can be several projects in one that is why we break it down by manufacturing line). I also have tabs for each line and a tab for total of parts required. What I wish to do is, when a quantity is filled in for a any part it automatically copies that part number and description to the associated line tab and also populates the total parts tab. This allow us to have a separate BOM per line and a total of parts needed for the entire project. I cannot use macros and have no knowledge of VBA. Looking perhaps for a formula that may accomplish this.
Thank you
I am trying to make a BOM template. In one tab I have a part selector list which includes Part number in A16, part description in B16 and quantity in J16, Then I have 7 columns each with a different line( our projects can be several projects in one that is why we break it down by manufacturing line). I also have tabs for each line and a tab for total of parts required. What I wish to do is, when a quantity is filled in for a any part it automatically copies that part number and description to the associated line tab and also populates the total parts tab. This allow us to have a separate BOM per line and a total of parts needed for the entire project. I cannot use macros and have no knowledge of VBA. Looking perhaps for a formula that may accomplish this.
Thank you