Using VBA to update workbook B extracting data from workbook A

[Rafaa]

Hi,


In order to do the tests, I'm using 2 simplified workbooks (test_copy and test_paste).

What I'd like to be able to do, once I click a button UPLOAD (creating the button isn't the problem), is to go to the first cell from workbook test_copy, check if that code is already on test_paste and if not add it to the bottom of the list, repeating the same cycle for each code on the workbook test_copy.

The orders of the codes might change on both workbooks differently depending on the way the columns are sorted. That is why I believe that for each code in test_copy I need to check the entire column in test_paste to check if the code already exists.

At the end of the routine, on the example below, we would have the codes 2670, 2676 and 2626 added to the end of the list on test_paste.

test_copy

Excel 2012

	A

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2684[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]2783[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]2669[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]2670[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]2676[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]2681[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]2601[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]2626[/TD]

</tbody>

Sheet1​

test_paste

Excel 2012

	A

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2684[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]2783[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]2669[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]2681[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]2601[/TD]

</tbody>

Sheet1​

Thank you very much in advance for your assistance.


Kind regards,


Rafael

 

[Rafaa]

Hi hiker95,


It worked perfectly! =D

Thank you once again mate!


Cheers,


Raf

 

[hiker95]

Rafaa,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.