Help!

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

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  NUMBER SEQUENCE GENERATOR  
Author Message
cahduq
External


Since: Jun 27, 2007
Posts: 1



PostPosted: Wed Jun 27, 2007 1:28 pm    Post subject: How do I copy a formula from one worksheet to another?
Archived from groups: microsoft>public>excel>newusers (more info?)

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?
Back to top
Gordon
External


Since: Nov 15, 2006
Posts: 1286



PostPosted: Wed Jun 27, 2007 9:48 pm    Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"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
Back to top
Norm
External


Since: May 17, 2007
Posts: 4



PostPosted: Wed Jun 27, 2007 10:28 pm    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Gail Richner
External


Since: Jun 22, 2007
Posts: 5



PostPosted: Sun Jul 01, 2007 1:30 pm    Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Eltayeb Elsheikh Bakheet
External


Since: Apr 13, 2009
Posts: 1



PostPosted: Mon Apr 13, 2009 10:09 am    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"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?
Back to top
mubashir aziz
External


Since: Apr 16, 2009
Posts: 1



PostPosted: Thu Apr 16, 2009 1:10 pm    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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/showthread.php?t=85497
Back to top
Louis de Pointe du Lac
External


Since: Nov 02, 2009
Posts: 1



PostPosted: Mon Nov 02, 2009 8:23 pm    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here's my scenario.
Microsoft Excel 2003 (11.8033.8028) SP2

I have 'Reporting Workbook Days 1-7'
I also have 'Reporting Workbook Days 8-14'.

The master template from which both were created, had a formula error (so
the rows are summing 'off' by one row).
Example:
On Row 69, the formula in cell D69 shows:
=SUM('Mon 10.12'!D68,'Tue 10.13'!D68,'Wed 10.14'!D68,'Thu 10.15'!D68,'Fri
10.16'!D68,Sun!D68,Sat!D68)

All of those !D68 's should be !D69 's. (And this general process repeats
across for *Columns* D through X.

So, I will go through and manually correct each one.
I will do this for all of the affected rows (12 rows, and 21 columns).
That will have manually corrected 'Reporting Workbook Days 1-7'.

However, when I try to copy these formulas over to 'Reporting Workbook Days
8-14', the formula (no matter what I choose) insists on referencing the
original workbook.
I don't want another copy of the data from Days 1-7, I want to instead
correct the erroneous formulas for Days 8-14.
(And the other 120 or so days that need to be fixed, one week at a time.)

I'd love to only do the manual work once, instead of many many times.

Anyone have a process for me?

Separately, is there a faster way other than manually updating 12x21 cells
for correcting the initial workbook (which I will then use as a template for
the others) ?


Thank you for any assistance you can provide.
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Mon Nov 02, 2009 9:25 pm    Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Have you tried an Edit>Replace>Lookin>Formulas

What: D68

With: D69

Secondly...............to copy formulas that reference sheets as yours do,
one method is to do an Edit>Replace in source workbook.

What: =

Wioth: ^^^

Replace all.

Copy to new workbook then reverse the edit>replace.

Another methos is to copy as is then Edit>Links>Change Links to the current
new workbook.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 15:23:01 -0800, Louis de Pointe du Lac
wrote:

>Here's my scenario.
>Microsoft Excel 2003 (11.8033.8028) SP2
>
>I have 'Reporting Workbook Days 1-7'
>I also have 'Reporting Workbook Days 8-14'.
>
>The master template from which both were created, had a formula error (so
>the rows are summing 'off' by one row).
>Example:
>On Row 69, the formula in cell D69 shows:
>=SUM('Mon 10.12'!D68,'Tue 10.13'!D68,'Wed 10.14'!D68,'Thu 10.15'!D68,'Fri
>10.16'!D68,Sun!D68,Sat!D68)
>
>All of those !D68 's should be !D69 's. (And this general process repeats
>across for *Columns* D through X.
>
>So, I will go through and manually correct each one.
>I will do this for all of the affected rows (12 rows, and 21 columns).
>That will have manually corrected 'Reporting Workbook Days 1-7'.
>
>However, when I try to copy these formulas over to 'Reporting Workbook Days
>8-14', the formula (no matter what I choose) insists on referencing the
>original workbook.
>I don't want another copy of the data from Days 1-7, I want to instead
>correct the erroneous formulas for Days 8-14.
>(And the other 120 or so days that need to be fixed, one week at a time.)
>
>I'd love to only do the manual work once, instead of many many times.
>
>Anyone have a process for me?
>
>Separately, is there a faster way other than manually updating 12x21 cells
>for correcting the initial workbook (which I will then use as a template for
>the others) ?
>
>
>Thank you for any assistance you can provide.
Back to top
Rod
External


Since: Dec 13, 2004
Posts: 76



PostPosted: Wed Mar 31, 2010 11:58 pm    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"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?
Back to top
ratcat
External


Since: Apr 01, 2010
Posts: 1



PostPosted: Thu Apr 01, 2010 12:10 pm    Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Copy the cell then right click on the cell in the another worksheet
then select 'Special Paste' then select 'Value' then click OK.

Cheers

RC


--
ratcat
------------------------------------------------------------------------
ratcat's Profile: 1563
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192130

http://www.thecodecage.com/forumz
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum