Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|