Copying individual sheets from 1 worksheet to another

[David]

I would like to copy an entire sheet (tab) from one worksheet to
another. It seems easy at first. I merely "select" all the cells in
the source sheet (tab) in the source worksheet, copy to the clipboard
(^C), select the destination sheet (tab) in the destination worksheet,
and paste from the clipboard (^V).

This works fine except, formatting is not copied. How do I do the
copy if I want to copy the formatting, headers, footers, etc.?

Dave

 

[Ron de Bruin]

With both workbooks open

Right click on a sheet tab and choose "Move or copy
Select the sheet you want

Change "to book" to the destination book

And check "create a copy"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


in message news:[email protected]...

 

[Bernard Liengme]

Use the Window command on menu bar to arrange the two workbooks side by side
Click the tab of the source worksheet (the tab is the little thing at bottom
of a worksheet)
Hold down the CTRL key and drag with the mouse (watch icon representing a
piece of paper) to the tab line in the target worksheet.

If you hold down SHIFT rather than CTRL then the worksheet is moved, not
copied
best wishes