Click OK. Excel will open a new workbook with the copied sheet. If you’re using Excel 2007, do the following: Select the tab of the sheet you want to copy (or move).

How to Copy Columns in Excel Using VBA. Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks.