Copy Sheet
 

Good Morning all

We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a diferent
workseet?

Regards,

Bre-x

Copy Sheet
 

This from VBA help file. Creates a new sheet and copies.

Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

If you want to copy from Sheet 1 to Sheet 2

Worksheets(1).Cells.Copy Worksheets(2).Range("A1")

"John Mamani" wrote:

Good Morning all

We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a diferent
workseet?

Regards,

Bre-x

Copy Sheet
 

Hi,
Thank you for you quick answer.

This is to copy sheet between the same worksheet right?

We need to copy sheets from another worksheet.



"JLGWhiz" wrote in message
...
This from VBA help file. Creates a new sheet and copies.

Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

If you want to copy from Sheet 1 to Sheet 2

Worksheets(1).Cells.Copy Worksheets(2).Range("A1")

"John Mamani" wrote:

Good Morning all

We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a
diferent
workseet?

Regards,

Bre-x

Copy Sheet
 

The first one copies a worksheet, creates a new worksheet in the same
workbook with the data from to copied worksheet.

The second one copies the data in a worksheet to an existing worksheet in
the same workbook.

For more information, see this website.

http://www.rondebruin.nl/folder.htm

"John Mamani" wrote:

Hi,
Thank you for you quick answer.

This is to copy sheet between the same worksheet right?

We need to copy sheets from another worksheet.



"JLGWhiz" wrote in message
...
This from VBA help file. Creates a new sheet and copies.

Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

If you want to copy from Sheet 1 to Sheet 2

Worksheets(1).Cells.Copy Worksheets(2).Range("A1")

"John Mamani" wrote:

Good Morning all

We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a
diferent
workseet?

Regards,

Bre-x

Copy Sheet
 

I didnt explain myself well.
Here is what I was looking for:

Sheets.Add Type:= _
"F:\1CNC\APPS\EXCEL\template_01.xls"

Thank you all for you help


We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a
diferent workseet?

Regards,

Bre-x