Eyrinn
11-28-2017, 02:15 PM
Hi There,
I need help merging 2 excel worksheets together in one workbook. I have been self teaching Programming with VBA for this project but I just don't have enough knowledge and experience to create/fix this code. We had a working code, but I did not create it and cannot fix it either, this is why I have been self teaching to try and understand what the codes mean to see if I can fix it. The reason the code does not work is because they changed the layout of the BOM
I have to take a Build of Materials (BOM) Report as the main page, and merge certain columns from a daily Materials report, and I need to make it automatic. so anyone can open this template that was created and update the materials report tab and it will automatically update the BOM report tab.
the trick to this is the BOM Structure can not change. due to certain levels each piece of material is at. some are at a level 1 some are at level 2 and some are lower level 3,4, 5. So they have to stay in that order. So taking the column of Material part number and sorting the BOM is not going to work.
Step1:
Paste the daily materials report into the second tab of the workbook and then remove 75% of the columns as only certain ones are required. I always mark the column title in Yellow so I know which ones not to remove
Step2:
I would need to find a way to take the material numbers from the Daily Materials report and match them to the material numbers in the BOM. 2 things should happen:
1. If the material matches - I need to take the remaining data in each material row from the daily material report and move it to the end of the row that matches the materials number in the BOM Report
2. The Material number does not match - The material number will be added to the end of the material Column in the BOM (Say column B and row 8 is the last row, the materials number would be entered into Cell B9) then the remaining data from the daily materials report will be added to Row 9 but in Columns j.k.l.m.n.
Please help if you can I would really appreciate it.
Erin :)
I need help merging 2 excel worksheets together in one workbook. I have been self teaching Programming with VBA for this project but I just don't have enough knowledge and experience to create/fix this code. We had a working code, but I did not create it and cannot fix it either, this is why I have been self teaching to try and understand what the codes mean to see if I can fix it. The reason the code does not work is because they changed the layout of the BOM
I have to take a Build of Materials (BOM) Report as the main page, and merge certain columns from a daily Materials report, and I need to make it automatic. so anyone can open this template that was created and update the materials report tab and it will automatically update the BOM report tab.
the trick to this is the BOM Structure can not change. due to certain levels each piece of material is at. some are at a level 1 some are at level 2 and some are lower level 3,4, 5. So they have to stay in that order. So taking the column of Material part number and sorting the BOM is not going to work.
Step1:
Paste the daily materials report into the second tab of the workbook and then remove 75% of the columns as only certain ones are required. I always mark the column title in Yellow so I know which ones not to remove
Step2:
I would need to find a way to take the material numbers from the Daily Materials report and match them to the material numbers in the BOM. 2 things should happen:
1. If the material matches - I need to take the remaining data in each material row from the daily material report and move it to the end of the row that matches the materials number in the BOM Report
2. The Material number does not match - The material number will be added to the end of the material Column in the BOM (Say column B and row 8 is the last row, the materials number would be entered into Cell B9) then the remaining data from the daily materials report will be added to Row 9 but in Columns j.k.l.m.n.
Please help if you can I would really appreciate it.
Erin :)