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. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|