Data transfer between workbooks

Filip88 · #1 09-23-2017, 05:48 AM

Hello,

Do you have any hint how to quickly transfer data from one workbook to another?

I have programmed macro to open random workbook, i want to transfer data from that opened workbook into the main workbook (the one i have macro). i have tried to use for loop, but considering thousands rows to be transfered it takes lots of time to finish the macro.

Is here any other way how to transfer data? Or maybe speed up for loop code? It takes 2 minutes to finish the code :s

Thank you for any reply

Filip

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to look up data from one of two workbooks	ColM1	Excel	2	09-10-2016 01:47 AM
Syncing data between two excel workbooks using multiple criteria	Merlot	Excel	2	05-04-2016 06:41 AM
Formulas transferring to other pages in workbooks, but data isn't.	Melissa Ames	Excel	4	03-02-2016 01:58 PM
Pull the data from different closed workbooks paste into master vba	manilara	Excel Programming	2	11-19-2015 08:41 PM
How to transfer my data?	dexoey	Outlook	0	09-15-2012 05:44 AM