Copy an entire worksheet to a new worksheet in Excel 2010

how to copy excel sheet to another sheet
how to copy excel sheet to another sheet with same format
copy excel sheet to another workbook with formulas
copy excel sheet to another workbook vba
how to copy data from one excel sheet to another
how to copy multiple sheets in excel to new workbook
how to copy excel sheet with formulas
excel copy data from one sheet to another automatically

I have found similar questions that deal with copying an entire worksheet in one workbook and pasting it to another workbook, but I am interested in simply copying an entire worksheet and pasting it to a new worksheet -- in the same workbook.

I'm in the process of converting a 2003 .xls file to 2010 .xlsm and the old method used for copying and pasting between worksheets doesn't paste with the correct row heights. My initial workaround was to loop through each row and grab the row heights from the worksheet I am copying from, then loop through and insert those values for the row heights in the worksheet I am pasting to, but the problem with this approach is that the sheet contains buttons which generate new rows which changes the row numbering and the format of the sheet is such that all rows cannot just be one width.

What I would really like to be able to do is just simply copy the entire worksheet and paste it. Here is the code from the 2003 version:

ThisWorkbook.Worksheets("Master").Cells.Copy
newWorksheet.Paste

I'm surprised that converting to .xlsm is causing this to break now. Any suggestions or ideas would be great.

It is simpler just to run an exact copy like below to put the copy in as the last sheet

Sub Test()
Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Worksheets("Master")
ws1.Copy ThisWorkbook.Sheets(Sheets.Count)
End Sub

How to Copy or Move a Worksheet into Another Workbook in Excel, How do I make multiple copies of a sheet in Excel? Step 2: Right-click the worksheet tab at the bottom of the window, then select the Move or Copy option. Step 3: Click the drop-down menu under To book: and select the name of the workbook to which you wish to copy the original worksheet. Step 4: Select the location in

ThisWorkbook.Worksheets("Master").Sheet1.Cells.Copy _
    Destination:=newWorksheet.Cells

The above will copy the cells. If you really want to duplicate the entire sheet, then I'd go with @brettdj's answer.

Move or copy worksheets or worksheet data, Move or copy entire sheets or selected sheet data to other locations in the same or another Duration: 0:52 Posted: Jul 19, 2015 Copy Worksheet in Excel 2007 & 2010. First open the workbook with the sheet you want to copy, right-click on the sheet tab and select Move or Copy. Make sure you have the workbook(s) that you want to copy the sheet into open for them to show up in the “To book” dropdown list, then choose the one to copy to.

' Assume that the code name the worksheet is Sheet1

' Copy the sheet using code name and put in the end.
' Note: Using the code name lets the user rename the worksheet without breaking the VBA code
Sheet1.Copy After:=Sheets(Sheets.Count)

' Rename the copied sheet keeping the same name and appending a string " copied"
ActiveSheet.Name = Sheet1.Name & " copied"

Copy an Excel sheet from one workbook to another, Click the sheet tab in the source workbook and drag it to the target workbook. If you want to copy the sheet instead of move it, hold down the [Ctrl]  Since in Excel 2010 pre-defined hotkeys enables user to get work done quickly, there is one hotkey combination which you can use to copy the worksheet without any hassle. To instantly copy the whole worksheet, hold Ctrl button and drag the worksheet tab to left or right side to copy the worksheet.

I really liked @brettdj's code, but then I found that when I added additional code to edit the copy, it overwrote my original sheet instead. I've tweaked his answer so that further code pointed at ws1 will affect the new sheet rather than the original.

Sub Test()
    Dim ws1 as Worksheet
    ThisWorkbook.Worksheets("Master").Copy
    Set ws1 = ThisWorkbook.Worksheets("Master (2)")
End Sub

How to Copy Excel 2010 sheet to another workbook, This tutorial will show you how to take a worksheet from one workbook and insert it into Duration: 1:07 Posted: Jan 17, 2013 In Excel for the web, the option to move or copy a sheet isn’t available when you right-click a sheet tab, as it is in the Excel desktop application. In Excel for the web, you can achieve the same result by copying all of the data in the worksheet and pasting it into a blank worksheet in the other workbook.

'Make the excel file that runs the software the active workbook
ThisWorkbook.Activate

'The first sheet used as a temporary place to hold the data 
ThisWorkbook.Worksheets(1).Cells.Copy

'Create a new Excel workbook
Dim NewCaseFile As Workbook
Dim strFileName As String

Set NewCaseFile = Workbooks.Add
With NewCaseFile
    Sheets(1).Select
    Cells(1, 1).Select
End With

ActiveSheet.Paste

How to Copy Excel 2010 sheet to another sheet, In this tutorial you will learn how to copy an excel sheet to a new sheet in the same workbook Duration: 1:07 Posted: Jan 17, 2013 'Make the excel file that runs the software the active workbook ThisWorkbook.Activate 'The first sheet used as a temporary place to hold the data ThisWorkbook.Worksheets(1).Cells.Copy 'Create a new Excel workbook Dim NewCaseFile As Workbook Dim strFileName As String Set NewCaseFile = Workbooks.Add With NewCaseFile Sheets(1).Select Cells(1, 1).Select End With ActiveSheet.Paste

How To Copy Worksheets in Excel 2007 & 2010, Copy Worksheet in Excel 2007 & 2010​​ First open the workbook with the sheet you want to copy, right-click on the sheet tab and select Move or Copy. Make sure you have the workbook(s) that you want to copy the sheet into open for them to show up in the “To book” dropdown list, then choose the one to copy to. You can easily copy an entire worksheet in Excel to a new worksheet in the same file or even to a new, separate workbook file. The Move or Copy command allows you to easily move or copy a worksheet, with all of its data and formatting, to a new sheet or to a new book.

5 Ways to Duplicate Worksheets in Excel, Copying to another workbook: Select the workbook name from the To Book list, click Create a Copy, and then click OK. Moving a sheet to another  Learn Excel From Beginner to Advanced Today. Find The Perfect Excel Course For You! Join Over 50 Million People Learning Online with Udemy. 30-Day Money-Back Guarantee!

How to copy a sheet in Excel or move to another workbook, Copy information from one Excel sheet to another using formula. In case you don'​t want to copy the entire sheet, but only some part of it, select the  The most comprehensive library of free printable worksheets & digital games for kids. Get thousands of teacher-crafted activities that sync up with the school year.

Comments
  • A little wordy but a well written question
  • I'd suggest copying the used range in preference to all cells.
  • BTW, you don't need to select the new workbook and sheet to paste, just use NewCaseFile.Worksheets(1).Paste.