dont forgot u have to open both the files .......

"Kathy" wrote:

I have two Excel files containing several sheets each. How do I move a sheet
from one file (workbook) to another? I tried the move or copy function in
the file I want to move the sheet from, however, the file I want to move the
sheet to does not appear in the "To book" drop down list.