I am desperate need of assistance. In order to avoid a circular reference error, I need to copy/ paste special values from one cell to another cell if there is any change in the value of the original cell.
For example:
Copy-paste values from $P$32 to $P$23, if value in $P$32 changes.
Some details: cell $P$32 contains a formula calculating a %, which is tied to another calculation in an array of columns, the sum of which needs to be used in yet another calculation. The tie to cell $P$32 is causing a reference error issue, and I really prefer not to turn on iterative calculations.
Any assistance would be so incredible appreciated!
For example:
Copy-paste values from $P$32 to $P$23, if value in $P$32 changes.
Some details: cell $P$32 contains a formula calculating a %, which is tied to another calculation in an array of columns, the sum of which needs to be used in yet another calculation. The tie to cell $P$32 is causing a reference error issue, and I really prefer not to turn on iterative calculations.
Any assistance would be so incredible appreciated!
