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

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?

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" wrote in message
...
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?

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=395343