copying one sheet to another workbook

  • Thread starter Thread starter boschuster50
  • Start date Start date
B

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!
 
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
 
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.
 
I am only adding one sheet to the workbooks, I do not want all of the other
sheets to be formatted the same.
 
Back
Top