| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying one sheet to another workbook
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying one sheet to another workbook
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 InsertWorksheet. 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 On Thu, 30 Apr 2009 12:20:38 -0700, boschuster50 wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying one sheet to another workbook
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. -- Tammy "boschuster50" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying one sheet to another workbook
I am only adding one sheet to the workbooks, I do not want all of the other
sheets to be formatted the same. "Tammyp" wrote: 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. -- Tammy "boschuster50" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color formatting issue when copying excel sheet from workbook to o | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| When Copying a sheet, the whole workbook gets copied | Excel Discussion (Misc queries) | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Hybrid Mode
