Copying formulas to another worksheet

K

Krystina

Can anyone please help me, I am trying to copy a formula =(sump1:p3) from one
worksheet into a new worksheet. When I go to paste the formula the only
thing that comes up is =SUM(#REF!). Can I even copy and paste a formula from
one worksheet into a new worksheet? and if so how? Thanks
 
J

JudithJubilee

When you paste a formula it relatively changes the cell references to suit
where you have pasted it to. EG. If you pasted =sum(P1:p3) from cell P4 to
cell B4 it would change to =sum(B1:B3). However, if you pasted it to cell B2
it could not reasonably change the references. If you are pasting because you
want the anwsers to the formulas to appear in another sheet you can use Paste
Link.

Copy the cell(s) and then right-click the destination cell and choose Paste
Special. Click the Paste Link button. This will create a formula that
references the original location. =Sheet1!P4. This will then update as the
other sheets change. You can copy and paste full rows/columns and tables in
the same way.
 
D

Dave Peterson

If you don't want the formula to change, then copy the formula from the
formulabar and paste into the formulabar.
 

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

Copying formula into another worksheet 1
Copying Formulas from One Worksheet to Another -- Very Easy Questi 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy data from one worksheet to another 2
copy formula down a column and have cell references change within formula 5
How do I copy a formula from one worksheet to another? 11
Copy formula from one worksheet to another to get value in 2nd wks 1
Formula not copying over as before 1

Top