Move sheet to another workbook?

[Alpacino]

This might be simple but how do u cut one worksheet from one workbook to another??
Regards
Alan

PS Happy Easter

 

[VoG]

With code?

Sub MoveMe()
Workbooks("Book1.xlsm").Sheets("Sheet1").Move after:=Workbooks("Book2.xlsm").Sheets("Sheet3")
End Sub

 

[jonashvid]

Without VBA you can:

Right Click on the "Sheet1" name at the bottom of the screen.

Select "Move or Copy" option

Select the workbook you want to move it to

Select where you want the worksheet placed

If you want to remove the sheet from the original workbook then do not tick the "Create copy" option.

If you want to make a copy then you should of course tick the "Create Copy" option

 

[Alpacino]

Thank u.