I have a workbook file with multiple worksheets. Can I save out a single
worksheet into another file?

try <edit<Move or copy sheet
select "Create a copy" if you want to leave the main sheet in the original
select in "to book" select (new book)

Depending on what you want to do with the new sheet and what extra sheet
references there are in the sheet will influence what to do next.

If all you want is a hard copy of what was in the original sheet I would
select everything in the new sheet and copy and <paste special< values.

If you want the sheet to be able to update from the original book leave as is.

Save the new book by whatever name is appropriate.


"Tkaminski" wrote:

I have a workbook file with multiple worksheets. Can I save out a single
worksheet into another file?