ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to transfer data from one workbook to another via VBA (https://www.excelbanter.com/excel-discussion-misc-queries/197248-how-transfer-data-one-workbook-another-via-vba.html)

Adnan

How to transfer data from one workbook to another via VBA
 
I have a workbook called Transfer which is supposed to transfer data from one
workbook to another, (Book1 to Book2), these two workbooks are formatted the
same and have multiple sheets.

So were talking about three different workbooks, the one I need help on is
Transfer workbook which has a button to transfer Book1 to Book2 via some code
that goes copies data from Book 1 to 2.

I would really appreciate anyones help/tip or guidance as to what code I
should have or start with?

Thank you,
Adnan



All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com