Mar 07 2022 05:03 AM
Mar 07 2022 05:55 AM - edited Mar 07 2022 05:55 AM
Thanks! You cannot do this with formulas, since it causes circular references: the formula in F5 refers to F5 etc.
You need a bit of VBA code for that. See he attached version; you'll have to allow macros when you open it.