moving a worksheet..?
 

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

moving a worksheet..?
 

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

Roy wrote:

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

--

Dave Peterson

moving a worksheet..?
 

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

On Thu, 28 Sep 2006 18:43:01 -0700, Roy wrote:

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