Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying formulas to another worksheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying formulas to another worksheet
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. -- Hope this helps "Krystina" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying formulas to another worksheet
If you don't want the formula to change, then copy the formula from the
formulabar and paste into the formulabar. Krystina wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying and using formulas including worksheet names | Excel Discussion (Misc queries) | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) |