Excel VBA - How to Copy Sheets to Another Workbook

Excel VBA Learn how to copy sheets to another workbook.

The code used in this video:

Sub CopySheets()

Dim weeklyReportWorkbook As Workbook
Dim finalReportWorkbook As Workbook

Set weeklyReportWorkbook = Workbooks("Weekly Report")
Set finalReportWorkbook = Workbooks("Final Report")

Dim weeklyReportSheet As Worksheet

For Each weeklyReportSheet In weeklyReportWorkbook.Sheets
weeklyReportSheet.Copy After:=finalReportWorkbook.Sheets(finalReportWorkbook.Sheets.Count)
Next

End Sub

• #education
• #excel_vba_copy_sheets_to_another_workbook
• #copy_sheet_to_another_excel_file
• #excel_vba
• #visual_basic_for_applications