|A formula can only return a result into the cell in which it resides.|
In other words, a formula in DJ2 can not place a result in DK2. The formula in DJ2 can only place its result in DJ2.
The only way for a result to end up in DK2 is either via a formula that resides in DK2 or by using a macro that monitors DJ2 and then writes something into DK2 based on what it sees in DJ2.
Why can't you just put the formula in DK2?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03