Issue with copy worksheet code

[gururaj1986]

Hi All,

I am using the below code to copy a worksheet to another worksheet. But, what I am trying to achieve is that the workbook pastes this data onto an existing worksheet. Below code creates a new sheet and pastes the contents within. The reason why I am using this code is because the source file contains images, values & formats which I need in the target file (Check this sheet). Is there any way we can copy a worksheet (including formats & images) and paste it to an existing sheet in another existing workbook?

Can anyone please help me with this issue?

Worksheets("DailyPerformanceReport_rpt").Copy Workbooks("Check this sheet").Worksheets("ZISF")

Thanks,
Guru

 

[footoo]

Worksheets("DailyPerformanceReport_rpt").Cells.Copy Workbooks("Check this sheet").Worksheets("ZISF").Cells

This will not copy any macros attached to the sheet or its objects.

Alternatively, you could delete the destination sheet, copy the source sheet to the destination workbook, rename the sheet

 

[gururaj1986]

Worksheets("DailyPerformanceReport_rpt").Cells.Copy Workbooks("Check this sheet").Worksheets("ZISF").Cells

This will not copy any macros attached to the sheet or its objects.

Alternatively, you could delete the destination sheet, copy the source sheet to the destination workbook, rename the sheet

Hey, thanks for the reply Actually, this code does work in terms of copy pasting the entire sheet to the new workbook. I cannot do the rename sheet method because there are templates in a separate sheet in the Target file which is picking values from the sheet in which the data was supposed to get pasted. Any workaround for this?

 

[footoo]

I cannot do the rename sheet method because there are templates in a separate sheet in the Target file which is picking values from the sheet in which the data was supposed to get pasted. Any workaround for this?

Since the code does what you need, presumably you don't need to do it this way?