Forum Discussion
Cell that auto fills by if statement or allows manual input
The functional programming style of an Excel sheet formula is intended to prevent the reassignment of a new value to a cell such as you describe. On the other hand. an imperative programming language such as VBA is allowed to make such state changes. Hence HansVogelaar 's solution.
There is a trick that may achieve the effect you require without resorting to VBA. If you insert a new column D then a formula there can be made to display in column B, provided the cell in column B is blank. The default text in column D/C is heavily indented and right aligned in order to move it left into the adjacent cell.
The functional programming style of an Excel sheet formula is intended to prevent the reassignment of a new value to a cell such as you describe. On the other hand. an imperative programming language such as VBA is allowed to make such state changes. Hence HansVogelaar 's solution.
There is a trick that may achieve the effect you require without resorting to VBA. If you insert a new column D then a formula there can be made to display in column B, provided the cell in column B is blank. The default text in column D/C is heavily indented and right aligned in order to move it left into the adjacent cell.
- Peter could you explain to me how you pushed the output of the formula in D to column C. I am trying to do the same thing
- Thanks for the help, it's not quite as good as the one above, however works far better for me given i will be sharing this online and (to my knowledge) cant use VBA on shared files on one drive. Thanks Heaps. Keep up the great work.
