copying one sheet to another workbook

[boschuster50]

I have 100+ workbooks. each have to remain separate.
I created a sheet to add to each workbook with specific formatting.
I tried copy and paste, and lose the column and row formatting.
Also tried the edit; copy or move sheet, doesn't give me option of picking
the workbook I want to paste to. Please tell me I won't have to format each
sheet after pasting!

 

[Gord Dibben]

The workbook to copy the sheet into must be open.

With 100+ workbooks this will get a little tiresome.

One method would be to make a Template from a workbook containing only that
one formatted sheet.

Name this template SHEET.XLT

Store in your XLSTART folder.

Open each workbook and Insert>Worksheet.

Or try your hand at VBA.

Ron de Bruin has code for adding a sheet to every workbook in a folder.

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

See Item #4


Gord Dibben MS Excel MVP

 

[Tammyp]

Use the option of selecting all sheets and making adjustments needed. Just
remeber, if you make adjustments to one sheet it will make the adjustments to
all the sheets.

 

[boschuster50]

I am only adding one sheet to the workbooks, I do not want all of the other
sheets to be formatted the same.