Save Workshetts as Separate Files

[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?

 

[Ron de Bruin]

Hi Elvis

You can use a macro to mail every sheet to the correct group.

See example 2 on this page
http://www.rondebruin.nl/mail/folder1/mail2.htm

Or add a sheet template to the workbook if you not like code
http://www.rondebruin.nl/mail/templates.htm

 

[Roger Govier]

Hi Elvis

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