Copy sheets to mulitple workbooks in a directory

[Greg]

Hi. I need a hand with some code to copy/export 3 sheets into
multiple workbooks in a directory. These are newly formatted sheets
that are needed to be added to the existing workbooks.

All these workbooks are identically formatted and I would like to
insert the new sheets after sheet named "PVM". Thanks in advance.

 

[Ron de Bruin]

Start here
http://www.rondebruin.nl/copy4.htm

See the example
"Copy a worksheet to all workbooks in a folder"
You can change that to copy more then one sheet

 

[Byteya]

Start herehttp://www.rondebruin.nl/copy4.htm

See the example
"Copya worksheet to allworkbooksin a folder"
You can change that tocopymore then one sheet

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






- Show quoted text -

Thanks once again Ron. I did go to your website first as I usually do
when looking for code but this time I didn't find what I needed.
Thanks for pointing me in the right direction. The code is exactly
what I was looking for.