Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update two cells by changing another
In column A, I have salary. Column B has increase %, column C has
increase amount, column D has total new salary. I need a macro that allows me to update column B, C, or D by entering infomation in either of those. So, if someone enters an increase of 5% in column B on a 10,000 salary, then column C should change to $500 and column D should change to 10,500. Or, if they enter 10,500 in column D, the other two cells should change, etc. Can anyone help with this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update worksheet when changing another sheet | New Users to Excel | |||
update a sheet automatically with changing values from another she | Excel Worksheet Functions | |||
Why won't my pie charts update with changing data? | Charts and Charting in Excel | |||
Update date when changing a cell | Excel Programming | |||
How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) |