Copy/Paste Sheets from one workbook to others?

[klarowe]

Is there a way to set up a maco that will copy around 15 sheets from one workbook, add the necessary sheets to multiple other workbooks, and paste them into the new workbooks all while keeping the column/row formatting the same???

And if that is possible, is there an easy way to do the same with each sheet activate code?

Basically the first section of each workbook is the same (already have each finished) but I need to add on another 15 worksheets and if I could do it easily, rather than manually copying/pasting each and every sheet to each and every workbook, it would save me a lot of time and hassle.
Thanks again.

 

[klarowe]

NVMD... i knew the minute I posted the question I would find the answer... lol.

 

[struf]

I think you have what i am looking for.
Can you post what you found?
Thanks

 

[klarowe]

It wasn't by code. I just opened all of the books, then right click on a sheet (or multiple sheets), "move/Copy" and you can select what workbook you want to copy to.