General Betting
There is currently 1 person viewing this thread.
I am trying to equalise the value of two cells by changing a third.
I have looked at Goal Seek and solver but these both seem to require a specific numerical target wheras I just want the two cells to be equal.
Can anyone point me in the right direction please?
I have looked at Goal Seek and solver but these both seem to require a specific numerical target wheras I just want the two cells to be equal.
Can anyone point me in the right direction please?
sort by:
Show
per page
Replies: 4
|
By:
Put a formula in a third cell showing the diff between the two cells you want to equalize, e.g. A3= A2-A1
Goal Seek A3=0 |
|
By:
Thanks mouse trap! Is there any way to get the goal seek to work in a cell automatically or do you have to go via the menus every time? (or set up a macro button).
|
|
By:
NP. I have a macro button in my s/s; the macro is just one line ;-)
|
|
By:
If you want things done automatically why not use something like Worksheet_Change(ByVal Target As Range) to monitor any changes within the worksheet and have it fire the macro when values in that range had been changed
|