Copy data from one sheet to another

[abhiutd]

Hello!
I have created a worksheet using :
Dim wkSheet As Worksheet
Set newWkSheet = ActiveWorkbook.Sheets.Add

Now i want to copy data from another exiting sheet to this new blank sheet. How can i do that?
Any help would be greatly appreciated.

Thank You.

 

[scott-atkinson]

Hello!
I have created a worksheet using :
Dim wkSheet As Worksheet
Set newWkSheet = ActiveWorkbook.Sheets.Add

Now i want to copy data from another exiting sheet to this new blank sheet. How can i do that?
Any help would be greatly appreciated.

Thank You.

Windows("Name of your source workbook here.xls").Activate

Cells.Select ' This selects all cells in the active worksheet
Selection.Copy ' Copies all the cells to the clipboard
Windows("Name of your destination workbook here.xls").Activate ' Makes your destination book the active book
Cells.Select
Activecell.Paste

 

[abhiutd]

Hi Scott,
Thank you. I took your approach and i was able to do it by using only two statements sheet1.Copy and sheet2.PasteSpecial

Thanks again.