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