A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I copy a formula from one worksheet to another?



 
 
Thread Tools Display Modes
  #1  
Old June 27th, 2007, 05:28 PM posted to microsoft.public.excel.newusers
cahduq
external usenet poster
 
Posts: 1
Default How do I copy a formula from one worksheet to another?

I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?
  #2  
Old June 27th, 2007, 05:48 PM posted to microsoft.public.excel.newusers
Gordon
external usenet poster
 
Posts: 4,772
Default How do I copy a formula from one worksheet to another?

"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?



Copy-Paste Special-Values


  #3  
Old June 28th, 2007, 02:28 AM posted to microsoft.public.excel.newusers
Norm (I know nothing)
external usenet poster
 
Posts: 4
Default How do I copy a formula from one worksheet to another?

Hi

If you only want the result in another tab and don't care if it is next to
the sourse data, just cut and paste it to the tab you want it in. That will
preserve the relationship to the data.

Norm


"cahduq" wrote:

I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?

  #4  
Old July 1st, 2007, 02:30 PM posted to microsoft.public.excel.newusers
Gail Richner
external usenet poster
 
Posts: 5
Default How do I copy a formula from one worksheet to another?

Would it not be better to reference the cell where the formula is in case
the results change?


"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?



  #5  
Old September 14th, 2007, 09:40 PM posted to microsoft.public.excel.newusers
Que
external usenet poster
 
Posts: 4
Default How do I copy a formula from one worksheet to another?

How do you reference the cell? I have tried numerous times and cannot get it
right.

Thanks

"Gail Richner" wrote:

Would it not be better to reference the cell where the formula is in case
the results change?


"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?




  #6  
Old September 14th, 2007, 10:31 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default How do I copy a formula from one worksheet to another?

If all you want is the result, just copy then paste specialvalue.

You could on target sheet use =sourcesheet!A1

Or select the cell to copy and editreplace

What: =

With: ^^^

Copy the cell to next sheet then reverse the process.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 13:40:01 -0700, Que wrote:

How do you reference the cell? I have tried numerous times and cannot get it
right.

Thanks

"Gail Richner" wrote:

Would it not be better to reference the cell where the formula is in case
the results change?


"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?





  #7  
Old September 14th, 2007, 10:36 PM posted to microsoft.public.excel.newusers
George Gee
external usenet poster
 
Posts: 111
Default How do I copy a formula from one worksheet to another?

One way

In the destination cell, type "=" (without quotes),
click on the sheet tab of the cell that you wish to reference,
click on the cell that you wish to reference,
press 'Enter'.

George Gee


"Que" wrote in message
...
How do you reference the cell? I have tried numerous times and cannot get
it
right.

Thanks

"Gail Richner" wrote:

Would it not be better to reference the cell where the formula is in case
the results change?


"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell
in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?






  #8  
Old June 2nd, 2008, 04:51 PM posted to microsoft.public.excel.newusers
zylah
external usenet poster
 
Posts: 1
Default How do I copy a formula from one worksheet to another?

I have a similar problem, I have a large number of formulas that i need to
copy from one worksheet to another. Under the paste tab the Formula option is
greyed out. (i have checked in excel options\advanced\ cut, copy and paste
and all three options are ticked.)
I have saved the source workbook as a 2007 file too so that I am copying and
pasting to the same version of excel.
Any ideas


"cahduq" wrote:

I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?

  #9  
Old April 13th, 2009, 02:09 PM posted to microsoft.public.excel.newusers
Eltayeb Elsheikh Bakheet
external usenet poster
 
Posts: 1
Default How do I copy a formula from one worksheet to another?



"cahduq" wrote:

I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?

  #10  
Old April 16th, 2009, 01:10 PM posted to microsoft.public.excel.newusers
mubashir aziz[_3_]
external usenet poster
 
Posts: 1
Default How do I copy a formula from one worksheet to another?


Just put ' before existing formula now copy the while cell and paste in
new sheet (don't ignore to copy whole cell including ' ).

After pasting formula just move ' and your formula will be in shape but
make sure that the formula will work on relevant rows and columns only
.....


--
mubashir aziz
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85497

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.