gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I have two tables:
sheets("Step 3").ListObjects("User_PBoM")
sheets("Costpoint BoMs").ListObjects("BOM")
I want to move some of the field from the BoM to the last row of User_PBoM.
[Level], [Type], [Assembly], [Material], [Description], [Make/Buy] and [Qty Per] The field names are the same in both tables. Note: I am not copying all of the fields from BoM
Here is where I am stuck. Down the first column (column B) I have a filed named [Remove from PBoM?]. If the value in that row = "Remove from PBoM" I dont want to move/copy that Row.
What is the best way to do this in VBA? I dont want to delete those rows out of the BoM table - because I need that as a record that the user did want to move that row to the PBoM and I dont have a corresponding row in my USer_PBoM table where I can move all the data and then remove those rows after.
I assume I have to loop through each row of the BoM and copy and paste one row at a time.
Note: Column C can be used to find the Last row in each table.
Any help is appreciated.
Thanks
Greg
PS looking forward to the Microsoft Excel ESport challenge on ESPN this week!
sheets("Step 3").ListObjects("User_PBoM")
sheets("Costpoint BoMs").ListObjects("BOM")
I want to move some of the field from the BoM to the last row of User_PBoM.
[Level], [Type], [Assembly], [Material], [Description], [Make/Buy] and [Qty Per] The field names are the same in both tables. Note: I am not copying all of the fields from BoM
Here is where I am stuck. Down the first column (column B) I have a filed named [Remove from PBoM?]. If the value in that row = "Remove from PBoM" I dont want to move/copy that Row.
What is the best way to do this in VBA? I dont want to delete those rows out of the BoM table - because I need that as a record that the user did want to move that row to the PBoM and I dont have a corresponding row in my USer_PBoM table where I can move all the data and then remove those rows after.
I assume I have to loop through each row of the BoM and copy and paste one row at a time.
Note: Column C can be used to find the Last row in each table.
Any help is appreciated.
Thanks
Greg
PS looking forward to the Microsoft Excel ESport challenge on ESPN this week!