Excel move selected rows to new sheet

There are a few ways to move selected rows to a new sheet in Excel. Here are a few methods:

Method 1: Using the "Move" feature

1. Select the rows you want to move by checking the boxes in the row headers.
2. Go to the "Home" tab in the ribbon.
3. Click on the "Move" button in the "Cells" group.
4. Select "Move to a new sheet" from the dropdown menu.
5. Choose a new sheet name and location from the "Move to" dropdown menu.
6. Click "OK" to move the selected rows to the new sheet.

Method 2: Using the "Copy" and "Paste" features

1. Select the rows you want to move by checking the boxes in the row headers.
2. Go to the "Home" tab in the ribbon.
3. Click on the "Copy" button in the "Clipboard" group.
4. Go to the new sheet where you want to move the rows.
5. Right-click on the row header where you want to insert the rows.
6. Select "Paste" from the context menu.
7. Choose "Paste values" or "Paste formulas" depending on your needs.

Method 3: Using VBA code

1. Open the Visual Basic Editor by pressing "Alt + F11" or by navigating to "Developer" tab in the ribbon.
2. In the Editor, click on "Insert" > "Module" to insert a new module.
3. Paste the following code:

   Sub MoveSelectedRowsToNewSheet()
    Dim selectedRows As Range
    Set selectedRows = Selection
    Dim newSheet As Worksheet
    Set newSheet = Worksheets.Add
    selectedRows.Copy
    newSheet.Range("A1").Paste
    Application.CutCopyMode = False
   End Sub

4. Save the module by clicking "File" > "Save" (or press "Ctrl + S").
5. Go back to your Excel worksheet and select the rows you want to move.
6. Press "Alt + F8" to open the Macro dialog box.
7. Select the "MoveSelectedRowsToNewSheet" macro and click "Run".

Note: The above code will move the selected rows to a new sheet at the end of the workbook. If you want to move the rows to a specific location in the new sheet, you can modify the code accordingly.