View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
boschuster50 boschuster50 is offline
external usenet poster
 
Posts: 9
Default 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!