Copy & Paste Table Columns

Dear All

I have a situation where I need to copy specific columns from a table (secondary) and append them to another table (master). The 'master' table has a summary row at the bottom,

With reference to the code below I need to copy specific columns from tbl2 and paste the data into specific columns in new rows at the bottom of tbl1.

tbl2.Column2 goes to tbl1.Column4
tbl2.Column3 goes to tbl1.Column5
tbl2.Column4 goes to tbl1.Column6
tbl2.Column6 goes to tbl1.Column11
tbl2.Column7 goes to tbl1.Column12

The code performs the first 3 copies / pastes the data into new rows at the bottom of tbl1 ok. I am unsure how to expand this to copy the data from tbl1.Columns 6 and 7 and paste into tbl2.columns 11 and 12. If I repeat the Union the data is inserted into more new rows at then bottom of tbl1 where as I would like it to be inserted into the same rows created by the first paste operation.

Please Login or Register  to view this content.

Enclose an example of these two tables and the expected result, it will be easier to create a solution.