Vee said:
Is there a way if I make a change on one worksheet it shows on all the
others?
Your question isn't clear.
If you mean that a number changes on Sheet 1 (say in A1) and you want this
to affect the results of formulas in other sheets, simply reference this
cell in those formulas, including its sheet location, such as
=Sheet1!A1
However, if you mean you have many worksheets with identical formulas, and
you want to edit a formula in one cell on each of them in the same way, here
is what you do. Click the tab of the first sheet you want to edit. Hold down
SHIFT and click the tab of the last. This will select all the sheets; their
tabs will all go white. Then, edit your formula and it will be edited on all
sheets. DO NOT FORGET to deselect the range of sheets (click on another tab,
or right click a tab and use Ungroup sheets) as soon as you have finished
editing. Until you do this, whatever you do will change all the sheets!
Stephen
