copy worksheet and replace

Hi all,
I would like to ask how is possible make a copy of one specific worksheet
in workbook "a" and paste it in a existing worksheet in a Workbook "b"
replacing the content.

Thanks in advance.

Marco

You cannot copy a worksheet into another existing worksheet.

You can copy the contents of a sheet into an existing worksheet.

With both books open.....

In book "A" hit CTRL + a(twice in 2003) to select all then edit>copy.

Switch to book "B" and the sheet you wish to overwrite.

Edit>Paste.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 18:33:01 GMT, "chiandu" <[email protected]> wrote:

>Hi all,
>I would like to ask how is possible make a copy of one specific worksheet
>in workbook "a" and paste it in a existing worksheet in a Workbook "b"
>replacing the content.
>
>Thanks in advance.
>
>Marco
>
>