I don't have a very extensive background with excel, and no background with macros, but I have the feeling I will need to use a Macro to carry out the task in question..
I have two workbooks; one that serves as a database for all the materials my company ever uses, and another that servers as an individual Bill of Materials (BOM) for each project.
The database is complete, with columns for partID, name, manufacturer, part#, etc. It also has every part occurring only once, as it should. Therefor, each part# should only occur once.
The BOM, however, has many instances where parts are repeated because the same part can be used in many different sections of the project.
The BOM does have a column for partID, but it has not yet been filled in, and I am trying to avoid filling it in manually, as there are 1000s of parts listed.
It also has columns for name, manufacturer, part#, etc, all of which are already populated. The name could be a long description, and the manufacturer can be the same across many parts, so to me, the part# column is the useful identifier between the two workbooks.
So basically, I am assuming that I will need to write some sort of macro procedure that will copy partID from the Database.xlsx to BOM.xlsx if column "part#" is the same between the two workbooks. Is this correct to assume?
Any tips or references of where to start? Anything would be helpful!
Thanks!
I have two workbooks; one that serves as a database for all the materials my company ever uses, and another that servers as an individual Bill of Materials (BOM) for each project.
The database is complete, with columns for partID, name, manufacturer, part#, etc. It also has every part occurring only once, as it should. Therefor, each part# should only occur once.
The BOM, however, has many instances where parts are repeated because the same part can be used in many different sections of the project.
The BOM does have a column for partID, but it has not yet been filled in, and I am trying to avoid filling it in manually, as there are 1000s of parts listed.
It also has columns for name, manufacturer, part#, etc, all of which are already populated. The name could be a long description, and the manufacturer can be the same across many parts, so to me, the part# column is the useful identifier between the two workbooks.
So basically, I am assuming that I will need to write some sort of macro procedure that will copy partID from the Database.xlsx to BOM.xlsx if column "part#" is the same between the two workbooks. Is this correct to assume?
Any tips or references of where to start? Anything would be helpful!
Thanks!
Last edited:
