Hi There,
I am in need of help. I have been working on this issue for quite some time and I am just not experienced enough in Programming with VBA to complete my task.
I have to merge 2 worksheets together in one workbook.
The first sheet is a Bill of Materials - Titled BOM - Sheet 1
the second sheet is the daily materials report I would paste into it - Titled Materials Sheet - Sheet 2
My first step would be to Delete all the columns on the materials sheet (Sheet 2) that are no longer needed for the merge. The ones need to have deleted are Sheet 2 - Columns A-P, S-U, W,Y, AC-AE, AG, AJ-AM (Keeping only Columns Q-P,V, X, Z-AB, AF, and , AH - AI Which are then moved to Columns A - J)
I then need to be able to Take the Column with the materials part number (A) in the materials Sheet (Sheet - 2) and go into the BOM Sheet (Sheet 1) to Column B (CT Part#) and try to match the materials part numbers.
If the material numbers match, I need to have the remaining data From Materials Sheet (Sheet 2) Columns B-J moved to the end of each matching Material row in the BOM Sheet (Sheet 1). Those would be columns BB - BJ. So if a material number matches a material number in Row 8 the remaining data in the Materials Sheet (Sheet 2 columns B-J) would be moved to Row 8 Cells BB-BJ
Then, The Material Numbers that do not match needs to be added to the end of the list. So if the List stops at row 858 the non matching material numbers would be entered into Cell B859 and the Remaining data for that materials would be entered into Cells BB859 -BJ859.
the challenging part is this will be used for many projects and the BOM data will not always be the same. there will be different amount of rows.
the same with the Materials Sheet.
Please let me know if I can give more info as I do have templates in excel already created. I just don't think i can upload them to the forum.
Please let me know if you can help
thank you so much for your help
Erin Motil
I am in need of help. I have been working on this issue for quite some time and I am just not experienced enough in Programming with VBA to complete my task.
I have to merge 2 worksheets together in one workbook.
The first sheet is a Bill of Materials - Titled BOM - Sheet 1
the second sheet is the daily materials report I would paste into it - Titled Materials Sheet - Sheet 2
My first step would be to Delete all the columns on the materials sheet (Sheet 2) that are no longer needed for the merge. The ones need to have deleted are Sheet 2 - Columns A-P, S-U, W,Y, AC-AE, AG, AJ-AM (Keeping only Columns Q-P,V, X, Z-AB, AF, and , AH - AI Which are then moved to Columns A - J)
I then need to be able to Take the Column with the materials part number (A) in the materials Sheet (Sheet - 2) and go into the BOM Sheet (Sheet 1) to Column B (CT Part#) and try to match the materials part numbers.
If the material numbers match, I need to have the remaining data From Materials Sheet (Sheet 2) Columns B-J moved to the end of each matching Material row in the BOM Sheet (Sheet 1). Those would be columns BB - BJ. So if a material number matches a material number in Row 8 the remaining data in the Materials Sheet (Sheet 2 columns B-J) would be moved to Row 8 Cells BB-BJ
Then, The Material Numbers that do not match needs to be added to the end of the list. So if the List stops at row 858 the non matching material numbers would be entered into Cell B859 and the Remaining data for that materials would be entered into Cells BB859 -BJ859.
the challenging part is this will be used for many projects and the BOM data will not always be the same. there will be different amount of rows.
the same with the Materials Sheet.
Please let me know if I can give more info as I do have templates in excel already created. I just don't think i can upload them to the forum.
Please let me know if you can help
thank you so much for your help
Erin Motil
