If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro to COPY ONE worksheet into MULTIPLE files in a folder. Also, delete a worksheet from multiple workbooks.

Thread starter bpo
Start date May 2, 2012
Tags

copy a worksheet delete a worksheet macro multiple files

bpo

New Member

May 2, 2012

Hi Excel experts, hope somebody is smarter than I am with this stuff:

1. Does anyone know of macro script that I can use to copy the SUMMARY worksheet from MASTER.xls into all the files in the folder "R:\Projects\Hospitals"?

-I have a folder full of Excel workbooks. "R:\Projects\Hospitals"
-Each of these workbooks needs a copy of the same worksheet called SUMMARY (currently saved in a file called MASTER).

2. Is there a macro that can delete worksheet "HCO" from every workbook in "R:\Projects\Hospitals"?

-Each of the files in "R:\Projects\Hospitals" has a worksheet called "HCO" that needs to get deleted, and it would be a real pain in the neck to do it manually.

Thanks everybody -- this would be a HUGE time savings and far less room for error.

Best,
Brady