Hi Cristine,

right click on the tab name, select -- Move or Copy --

Check the create a copy box, and on the drop down box chose -- new workbook.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Christine" escreveu:

Is it possible to save just one sheet out of a multiple sheet workbook under
a different name?
If not is there a formula that I can use that will automatically copy the
information I enter in one workbook into a seperate workbook sheet?