Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Copy/Paste data - Copy the Entire data from one sheet to another

In VBA-Excel, Copy and paste the data plays an important role, we can copy data from one place and paste it at some other place in the same way like how we do it manually, and when you copy some data its goes to the Clipboard from there you can paste it at some other location.

Dim mainworkBook As Workbook

Set mainworkBook = ActiveWorkbook

Copy  the Entire data from one sheet to another

For example if you want to copy the data “Sheet1” and paste it to in “Sheet2”.

For copy the data present in “Sheet1”

mainworkBook.Sheets("Sheet1").UsedRange.Copy

now the data has been copied to clipboard, you can check it by manually pasting it in a notepad.

Now select the cell in which you want to paste the data, in this example its “B2” in “Sheet2”

mainworkBook.Sheets("Sheet2").Select

mainworkBook.Sheets("Sheet2").Range("A1").Select

Now paste the data

mainworkBook.Sheets("Sheet2").Paste



Also Read:

  1. Introduction to Excel WorkBook
  2. VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
  3. How to Enable Macro in Excel
  4. VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
  5. VBA-Excel: Delete Blank Rows from Excel Work Sheet
  6. Getting Started with Excel Macro
  7. VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
  8. VBA Excel – Looping Through a Range of Cells