Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and replace | Excel Discussion (Misc queries) | |||
copy & replace questions | Excel Discussion (Misc queries) | |||
find and replace help with copy paste | Excel Discussion (Misc queries) | |||
Copy over files/replace (complete question) | New Users to Excel | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions |