You can easily do =worksheet!cell and copy down and/or across. You don't
have to type each one in. :)
You can also copy, then go to the new workbook, and hit Edit--Paste
special--Paste link.
************
Anne Troy
www.OfficeArticles.com

"Marsha" wrote in message
...
I have a worksheet in a workbook.... now I open a new workbook and I want
to
copy in full the worksheet from workbook one and since its huge I just
want
to use a formal to copy it over to the new workbook. I use
=worksheet!cell
to copy a cell from one area to another. Can't I do it to move a whole
worksheet?