Click OK, and Excel will move or copy the sheet to the target workbook. If you move to the target workbook file, which is still open, you will find a copy of the source worksheet.

When in an Excel sheet, click the Developer tab, click Macros in the Code group, choose the procedure in the resulting dialog shown in Figure A, and then click Run. Figure A The bare bones VBA code ...