Does anyone know how to copy a worksheet from one Excel file into another Excel file? If this can be done, please clue me in! Thanks!
Right-click on the tab containing the worksheet at the bottom on the screen and select copy. For the destination, specify another already-open Excel file.
If that makes no sense, look at this Microsoft webpage.
You can also left click the upper left corner box, the one between A & 1, that will select the entire sheet. You then hit Copy, open a clean worksheet, and paste into cell A1.
Beware if it references other worksheets within the old file, that can cause issues.