moving a worksheet..?

[Guest]

Good evening,
how do I take a worksheet from one wookbook and insert it in a diffeent
workbook, thx in advance

 

[Dave Peterson]

Open both workbooks.
Select the workbook with the worksheet to move or copy.
select the worksheet in that workbook.
Edit|Move or copy sheet

Follow that dialog options.

Remember to check that box at the bottom if you want to copy the sheet.

======
You can also get that dialog by rightclicking on the worksheet tab.

======
And if you use Window|Arrange|horizontal (say), you can simply click on the
worksheet tab and drag from one workbook to the other. (Use click and ctrl-drag
to copy.)

 

[Gord Dibben]

With both workbooks open.

Right-click on the sheet tab and "Move or Copy"

You can move it or copy to the other book under the "to book" option.


Gord Dibben MS Excel MVP