Pinterest Pixel

Copy Current Worksheet into a New Workbook Using Macros In Excel

Have a worksheet that you want to copy into a new worksheet? You can accomplish that with... read more

Download Excel Workbook
Bryan
Posted on

Overview

Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline

Have a worksheet that you want to copy into a new worksheet? You can accomplish that with a single line of Excel Macro code! It will copy the current worksheet into a new workbook.

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Copies your active worksheet into an entirely new workbook

Copy Source Code:


Sub CopyCurrentWorksheetToNewWorkbook()

'Copy the Current Worksheet
ThisWorkbook.ActiveSheet.Copy Before:=Workbooks.Add.Worksheets(1)

End Sub

Final Result: 

Copy Current Worksheet into a New Workbook Using Macros In Excel

Exercise Workbook:

Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline

Download excel workbookCopy-Current-Worksheet-into-a-New-Workbook.xlsm


STEP 1: Go to Developer > Code > Visual Basic

Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline

 

STEP 2: Paste in your code and Select Save. Close the window afterwards.

Copy Current Worksheet into a New Workbook Using Macros In Excel

 

STEP 3: Let us test it out!

Open the sheet containing the data, this is the one we want to copy to a new worksheet.

Copy Current Worksheet into a New Workbook Using Macros In Excel

Go to Developer > Code > Macros

Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline

Make sure your macro is selected. Click Run.

Copy Current Worksheet into a New Workbook Using Macros In Excel

With just one click, your active worksheet was copied to a new workbook!

See also  Highlight Cells with Comments Using Macros In Excel

 Copy Current Worksheet into a New Workbook Using Macros In Excel

 

How to Copy Current Worksheet into a New Workbook Using Macros In Excel

 

101 Macros Book

If you like this Excel tip, please share it
Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline
Copy Current Worksheet into a New Workbook Using Macros In Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...