Forum Discussion
Re: Populate back values entered based on value of a specific cell
Excel is an example of a functional programming language which is designed to prevent you the changes you want from happening. Excel values do not evolve during a calculation; they are immutable and, once calculated, their state does not change. Your 'form' on sheet 1 is not allowed to change the state recorded on the database sheet 'List'.
To get a workbook to operate the way you require, you will need to move away from basic worksheet formulae and use an imperative programming environment such as VBA or Microsoft Forms that will allow state change. Your Sheet 1 ceases to be a data input mechanism and is simply a report featuring data extracted from the data table.
No RepliesBe the first to reply