copy data and formulas from another worksheet

K

Karl Townsend

I'm trying to copy data and formulas from one worksheet to another.

Excel wants to link the two worksheets, not what i want. For example if
cell A1 contains =b1/c1, I just want that to appear in the new worksheet I
copy to. Excel puts the name of the other file in the cell.

There must be an easy way to do this. How?

Karl
 
D

Dave Peterson

Maybe you want to copy the original range
Select the destination
and
Edit|paste special|formulas
 
B

Bob Umlas

You can also change "=" to "x=" in the formulas you want to copy and when
you're done, change "x=" to "=" in both source & destination. No linking
will occur.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
making cells uncopyable 1
Email Worksheet Question 3
Scatter plot / Data from matrices? 1
Copy/Paste from one workbook to another not recognized by formulas 2
Copy a worksheet to a new workbook 6
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Show other cell if blank 5

Top