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?

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?

Anne, thanks for your help. Just one last point. I want the information to go
from one workbook to another one. Would it be =workbook!worksheet!cell
reference? And when you say cell and copy down and/or across... do you mean
it would say =worksheet!A1:Z25 ???

"Anne Troy" wrote:

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?

Do this, Marsha:
Open a blank workbook. Now go to your original, and select the top-left-most
cell and copy it. Go to your new workbook Sheet1, cell A1. Hit Edit--Paste
Special--Paste link. Now select cell A1 and using the fill handle to copy
across from A1 to (wherever). Then, select A1 to (whatever), and copy down
using the fill handle. Here's how to use the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Marsha" wrote in message
...
Anne, thanks for your help. Just one last point. I want the information to
go
from one workbook to another one. Would it be =workbook!worksheet!cell
reference? And when you say cell and copy down and/or across... do you
mean
it would say =worksheet!A1:Z25 ???

"Anne Troy" wrote:

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?