Excel - VBA to Copy data from one workbook

Hello,

All, I need to copy the last column from one workbook(test) and append it to the last column to another workbook (newtest). and the column must be added each time the new data been copied.

my data looks like: the last column in test.xlsx

test.xlsx newtest
ww35.5 ww35.5
30,669 0
5,717 0
0 0
0 0
2,834 0


After I copy and paste the last column from test.xlsx into newtest.xlsx

newtest

ww35.5
30,669
5,717
0
0
2,834
Please help me on how to do this. I am new in programming. Really seeking for help. Advance thanks.