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!