A file is a workbook.

Do you want to copy/move all sheets out a workbook to another workbook?

Simply save the workbook as another name.

You want to move some of the sheets to a new workbook?

Select the sheets by CTRL + click then right-click and "move or copy"

Select "create a copy" or not if you just want to move the sheets.

To destination.........new workbook or any open workbook.


Gord Dibben MS Excel MVP

On Tue, 18 May 2010 12:56:01 -0700, gail
wrote:

I have a workbook w/ sheets and need to get them out of the w/book and into a
file.
I have tried to move/copy
and also just copying the sheet.
Any ideas?