Macro to Take a Worksheet from One workbook and Move it to Another

[trevor2524]

Does anybody know a code that will take the worksheet found on an open workbook and move it to another workbook that is also open. This way I can transfer values easier. Any suggestions? Thanks for your help.

 

[JackDanIce]

Replace parts in red with names of your workbook/worksheet; try:

Sub MoveSheet()
Workbooks("name_src").Sheets("name").Copy Before:=Workbooks("name_dest").Sheets("name")
End Sub

name_src is the name of the workbook you are copying FROM.
name is the name of the sheet you wish to copy.

name_destis the name of the open workbook you want to copy TO.
name is the name of the sheet you wish to put the copied sheet before.