Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Moves the worksheet named Homes from the workbook named Planning xls to the workbook named Building Schedule xls, inserting the work
Sub move()
    Workbooks("Planning.xls").Sheets("Homes").Move , _
       Before:=Workbooks("Building Schedule.xls").Sheets(1)
End Sub