Can you tell me if I can automatically save an open sheet to a new file?

I have a workbook that calculates a job cost from Quotation, Ongoing and
Invoice on differnet sheets but would like to save the invoice sheet as an
additional seperate file.

Use the tab on the botytom of the worksheet (like sheet1). Right click the
button and check the Copy box. then open the pullown box with the workbook
name and select New book. Then save the new book.

"Danno 24/7" wrote:

Can you tell me if I can automatically save an open sheet to a new file?

I have a workbook that calculates a job cost from Quotation, Ongoing and
Invoice on differnet sheets but would like to save the invoice sheet as an
additional seperate file.