Using VBA to copy data from one workbook to another, updating from where the last data ended

[odartey]

Hello all,
Trust you are all doing very well.
I have a central workbook which i will call Master.
I have other workbooks which i will call,A & B
In workbook A, a sheet named Cashbook will also be found in the "Master Workbook"
And a sheet named Summary in Workbook A will also be found in "Master Workbook"
Now To The Task;
I want a VB code that will allow me to copy specific cells on a month on month basis based the CURLY BRACKETS used in the data i will be uploading from Workbook A , Cashbook Sheet to Master Workbook Cashbook Sheet, always updating from the last entry cell.
Same for Workbook B, Summary sheet to Master Workbook Summary Sheet , always updating from the last entry cell.
Passwords used in all sheets is 11
Thanks in advance and counting on your benevolent cooperation.
O.

 

[odartey]

Hello all,
I am back pleading for help on my question submitted.
Waiting patiently, please help
thanks
O.

 

[Luke M]

Hi odartey,

From your files, I'm not quite sure how you want the columns to match up. Thankfully, merging files together is a fairly commonly asked question. I'd suggest first checking if you can use this add-in:
http://www.rondebruin.nl/win/addins/rdbmerge.htm

Or, if you want to tinker with the code yourself, here's several pre-built templates:
http://www.rondebruin.nl/win/s3/win008.htm

Ron has done a lot of excellent coding work, and provides lots of comments in his code to help you understand what, if anything, needs changed.

 

[odartey]

Thanks Like M.I will look up the links you have provided.
Once again thanks