Can I change a cell and cause an automatic change in other cells

[Swissmiss]

Is there a function or formula that will allow me to make a change in one
cell on the work sheet and the program will automatically change one or more
designated cells with that same change?

[swatsp0p]

Simply refer to that cell in your other "designated" cells, as such:

If A1 is your base cell, in another cell enter =A1

When you change the value in A1, it will change in your other cell to show what is in A1

You could perform math functions as such: =25-A1
If you enter 10 in A1, your cell will show 15
change A1 to 20 and your cell will now show 5

HTH

Bruce

[Anne Troy]

Please describe the exact scenario. I'm sure we could be much more helpful
that way. Formulas will automatically change other cells, so your
question seems odd.
************
Anne Troy
www.OfficeArticles.com

"Swissmiss" <[email protected]> wrote in message
news:[email protected]...
> Is there a function or formula that will allow me to make a change in one
> cell on the work sheet and the program will automatically change one or
> more
> designated cells with that same change?