The code here is great...as always! Used your site many times!!!
However, I would like to take the code above a step further and only replace the 'linked portion of the formula' with the external value and keep the cell formula intact. But I don't know how.
if the linked value of "[Book1]Sheet1!$A$1" = 5
Replace the original linked cell formula:
Not just the final value of "50".