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?