I am trying to move/copy a excel sheet from one file into another. Both are of 2007 version (MS Office 2007) and kept open. But I am unable to copy as the list of workbooks, excepting the its own name, are not reflected in the Move/Copy window.
right click the sheet tab click move or copy select the book you want to copy or move it to and click ok
Bookmarks