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

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
>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:7D9D48E7-FEB5-4F79-8CFB-(E-Mail Removed)...
> 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
>>
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:7D9D48E7-FEB5-4F79-8CFB-(E-Mail Removed)...
> > 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
> >>
> >>
> >>
> >>
>
>
>

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
>
>
>