Nov 10 2020 06:13 AM - edited Nov 10 2020 06:17 AM
Nov 10 2020 06:26 AM - edited Nov 10 2020 06:27 AM
Just so I am understanding correctly... you would like a formula in cell C1 to be dependent on the values in cells A1 and B1 but if B1 changes and a value was already printed in C1, then C1 should not change?
Nov 10 2020 08:33 AM
The following VBA code will check for "0xE1" in cell A1 and 1 in cell B1. If true, then cell A1 will be copied and pasted to cell C1. If not, then nothing will be done.
If Range("A1") = "0xE1" _
And Range("B1") = 1 _
You can assign this code to a button or shortcut key using the Developer tab.