Pierce a cel so that formula is on all worksheets in a workbook

[Dirkasaurus]

Any one know how to write a formula in a cell that stays on sheet1, and have
all other worksheets use that formula to compute values for the same range
except use the value range of its own worksheet? When you update the formula
on sheet1 the other sheets reflect the change.

 

[Bill Kuunders]

Select all sheets by clicking on the tabs while holding <cntrl> button
(the tabs will become white)
when you enter the formula and when you edit the formula.
Regards
Bill K