shreport | 上海证券交易所上市公司定期报告下载 , 项目地址

I have two tables in my dataset and want to create a third table (result) from the 2 tables: table 1 and table 2. u can see my tables from below: enter image description here

as you can from the image above. the main task is as follows:

1. I need to write a loop that goes through table 1 (col_1) and table 2 (col_1), and checks if the values are equal. if so, it adds the col_1, col_2, col_3 from table and only col_3 from table 2 into the result table. the code i wrote works for these section
2. if they are not equal, it should append the rows from table one, and table 2 into the result table with our duplication. example can be seen in the above table. this is the challenging part that the code i wrote failed badly

here is the code i wrote:

i wrote a code in VBA to copy a selected columns from one worksheet to another.

I have been looking online for a solution but I keep getting an error no matter what I try.

I have about 20 worksheets and I want to copy the same range for each worksheet and merge them to another worksheet to create a report.

I was able to modify this solution below but it's still not working and I don't know why.

Any help is appreciatd.