General discussion

Locked

Copy Worksheet

By goofy28721 ·
Is there a way to copy a worksheet in workbook1 to a worksheet with the same name in workbook2. The only way I see to copy is to a whole new worksheet. I'd like to replace an existing worksheet with the copy. Thanks, Kent

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Copy Worksheet

by DKlippert In reply to Copy Worksheet

Have both workbooks open. Right click the sheet tab of the worksheet you want to copy.
Be sure to check copy and then choose where to place the copy. Once the copy is completed, you can delete the old sheet and rename the new one.
Or select all ofthe data in the first sheet and copy paste to the new one.

Collapse -

Copy Worksheet

by goofy28721 In reply to Copy Worksheet

The question was auto-closed by TechRepublic

Collapse -

Copy Worksheet

by kees.valkenswaard In reply to Copy Worksheet

To be fair. Your question is not quite clear to me. Suppose you have Workbook1 with a sheet named INPUT. If both workbooks Workbook1 and Workbook2 are open, just select sheet INPUT and use Edit, Move or Copy sheet? Select Workbook2 in the box To book: and choose where to place it in Workbook2. It will keep the name INPUT. If you did not check the Create a copy check box you will have moved the sheet. Default is move. Probably you want copy. Else, leave the check box blank.
There is, however, one small exception. If you had already a sheet INPUT in Workbook2, the new [or moved] sheet will have the name INPUT (2).
Solution? First delete the old sheet INPUT in Workbook2, or rename afterwards.
There may be another small problem. Once you move (or copy) a sheet containing references to range names on a different sheet, do not be surprised when you get some troubles.
This can be avoided by using the function ADDRESS if you know the names of sheets in both workbooks.
You can even use itfor referencing to sheets with different names, for instance by writing somewhere in a cell the name of the sheet which you want to reference and give this the same range name in both workbooks. [With move again risk of errors!]
Another solution would be to use the horrible function CELL, which can not be used in an international environment as the arguments are in the native language of your system. Even Excel XP which is supposed to be ideal for international environments does not seem to provide solutions.
Good luck.

Collapse -

Copy Worksheet

by goofy28721 In reply to Copy Worksheet

The question was auto-closed by TechRepublic

Collapse -

Copy Worksheet

by goofy28721 In reply to Copy Worksheet

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums