General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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?
Show More
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
Goal Seek A3=0
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).
NP. I have a macro button in my s/s; the macro is just one line ;-)
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
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539