Save Workshetts as Separate Files

  • Thread starter Thread starter Elvis
  • Start date Start date
E

Elvis

I have 3 weekly reports that must be sent to 3 different goups. I have each
as a separate Excel template. To fill them out, I have to open 3 instances of
Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
save each worksheet as a separate file for the purpose of sending the reports
to the right goups?
 
Hi Elvis

Right click on sheet Tab>Move or Copy>Select Copy>use dropdown on To>New
Workbook
 
Back
Top