Copy worksheets to control file
 

Does anyone know what code I could use to copy sheets from several files in
the same folder into a master control file?

Copy worksheets to control file
 

Check out Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the codes you find under his Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP

On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery"
wrote:

Does anyone know what code I could use to copy sheets from several files in
the same folder into a master control file?

Copy worksheets to control file
 

Thanks Gord, I'll have a look.

Jim
"Gord Dibben" wrote in message
...
Check out Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the codes you find under his Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP

On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery"

wrote:

Does anyone know what code I could use to copy sheets from several files
in
the same folder into a master control file?

Copy worksheets to control file
 

Good luck........note the "merge data from all workbooks in a folder" Add-in.


Gord

On Mon, 20 Jun 2011 22:05:05 +0100, "Jim Lavery"
wrote:

Thanks Gord, I'll have a look.

Jim
"Gord Dibben" wrote in message
.. .
Check out Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the codes you find under his Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP

On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery"

wrote:

Does anyone know what code I could use to copy sheets from several files
in
the same folder into a master control file?