Copy worksheets to control file

[Jim Lavery]

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

 

[Gord Dibben]

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

 

[Jim Lavery]

Thanks Gord, I'll have a look.

Jim

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

 

[Gord Dibben]

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


Gord