Hi all,

I am looking for a clean and fast method (for 2010) to copy with links a bunch (10) of worksheets (same column formats but with different ammount of rows) and concatenate into a central DATA sheet to be able to run pivots on.

In the past (before 2010) I had the following but this for some strange reason took forever to finish when running in macro mode in 2010. In debug mode (F8) seemed to run normally though.

Please Login or Register  to view this content.
Currently have the following running with very good speed (but without the links):

Please Login or Register  to view this content.
How do I turn on the pasting with links again while maintaining the speed?