Copy worksheet to multiple workbooks in a folder

**MysticGenius** · 07-04-2012, 11:41 PM

Hi,

I have a workbook called template.xlsx, and this has 3 sheets "template 1" "template 2" and "template 3"

I need to copy these 3 sheets into all other workbooks in a directory, there are about 45 in total. each of the 45 workbooks has EXACTLY the same sheet names withing the workbook.

It would need to copy everything from template.xlsx exactly, there are formula on template 1,2 & 3.

is this possible without me manually copying the sheets and changing all of the formula, as when i have tried copying manually the formulas link back to the original workbook the sheet came from.

Thanks in advance.

**arlu1201** · 07-05-2012, 03:17 AM

It will be good if you explain with the help of a sample file or files.

**MysticGenius** · 07-05-2012, 06:06 PM

Originally Posted by arlu1201

It will be good if you explain with the help of a sample file or files.

Hi,

I cant upload the data is to sensitive!

although what I am asking for is pretty simple, i need to copy 3 sheets containing formula from one master workbook called template 1, template 2 and template 3, to all other workbooks that are contained in a folder...

thanks

**arlu1201** · 07-12-2012, 07:10 AM

Even if you copy it via macros, the file will still link to the original file. In that case, you need to go to Edit Links and change the link to the current workbook.

Or if there are not too many formulae, they can be freshly input through code. Hence, i asked you for the sample file. You can put in sensitive data, as long as the format & the formulae match the original file.