Excel - VBA to Copy data from one workbook

Closed
sham29
Posts
1
Registration date
Wednesday September 7, 2011
Status
Member
Last seen
September 7, 2011
- Sep 7, 2011 at 04:06 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Sep 20, 2011 at 08:54 AM
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.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Sep 20, 2011 at 08:54 AM
Hi Sham29,

Combine the info from the following links:
https://ccm.net/forum/affich-610575-submit-button-macro
&
https://ccm.net/forum/affich-385128-excel-compare-data-in-two-worksheets#p613932 (Last comment)

Let me know if you can't figure it out.

Best regards,
Trowa
0