How do I copy the information from one workbook to another?

M

Marsha

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?
 
A

Anne Troy

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
 
M

Marsha

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 ???
 
A

Anne Troy

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/best_tips_for_using_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
 
Top