Should try to explain my wish with an example (not easy) assume the following .:
Cell B3 contains the string "Info1"
Cell B4 contains the string "Info2"
Cell B5 Is an empty cell
Cell D3 contains the formula "=B3" - shows "Info1"
Cell D4 contains the formula "=B4" - shows "Info2"
Cell D5 contains the formula "=B5" - shows "0"
Don’t know why “0” appears in cell D5, but I usually handle it with the formula OM(B5 = ""; ""; B5)
(Swedish LO) I can handle the above. But…, assume that an empty cell is inserted between B3 and B4, the following results occur.
Cell B3 contains the string "Info1"
Cell B4 Is now an empty cell
Cell B5 contains the string "Info2"
Cell B6 Is an empty cell
Cell D3 contains the formula "=B3" - shows "Info1"
Cell D4 contains the formula "=B5" - shows "Info2"
Cell D5 contains the formula "=B6" - shows "0"
My wish is that the formulas in cells D4 and D5 should not change. I want still show the contents of cells B4 and B5 like this.
Cell D3 contains the formula "=B3" - shows "Info1"
Cell D4 contains the formula "=B4" - shows "0"
Cell D5 contains the formula "=B5" - shows "Info2"
Is it possible?
How?