Move data from one table to another

[gheyman]

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!