Right click the tab of the worksheet you want to copy...highlight move or
copy sheet, a dialog box will open, click the copy box and there will be a
drop down for a new work book or any others that are open, choose the one you
want and the location you want the sheet to go to.

That should do it!

Have a good day.
--
Jules


"trainer07" wrote:

How can I copy data from one spreadsheet to another while keeping the
formats, column widths and row heights in tact? When I do a copy and paste,
the data doesn't look the same when it's pasted.