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

copy worksheet and replace
 

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

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

EditPaste.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 18:33:01 GMT, "chiandu" 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