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
  #11  
Old November 3rd, 2009, 12:23 AM posted to microsoft.public.excel.newusers
Louis de Pointe du Lac[_2_]
external usenet poster
 
Posts: 1
Default How do I copy a formula from one worksheet to another?

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.
  #12  
Old November 3rd, 2009, 01:25 AM 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?

Have you tried an EditReplaceLookinFormulas

What: D68

With: D69

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

What: =

Wioth: ^^^

Replace all.

Copy to new workbook then reverse the editreplace.

Another methos is to copy as is then EditLinksChange 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.


  #13  
Old April 1st, 2010, 03:58 AM posted to microsoft.public.excel.newusers
Rod
external usenet poster
 
Posts: 307
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?

 




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 11:12 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.