Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Repeating Fomulas in Excel
Moo (and Skip): Skip's VBA solution is the better approach. At times, we can get too caught up in Excel's sometimes quirky behavior and forget the power of the macros and functions we can build for ourselves. It might be possible to make the named function work the way you need it to, but it...- beowork49
- Post #9
- Forum: Microsoft: Office
-
Repeating Fomulas in Excel
Hmmm. I tried this several times and see it work so that the formula applies to the sheet in which it is entered. What version are you using? I am in Excel 97 SR2. Unfortunately, it does not pick up changes to the values in A1 and A2, only what they were when the named formula was referred to...- beowork49
- Post #6
- Forum: Microsoft: Office
-
Repeating Fomulas in Excel
Try Insert/Name/Define again; click your named formula (Global); it probably looks like this: "=Sheet1!A1+Sheet1!A2"; remove "Sheet1" from both places but leave the "!" so it looks like "=!A1+!A2"; click Add; check your results....- beowork49
- Post #4
- Forum: Microsoft: Office
