Capture previous values that have been inserted into the spreadsheet with the History add-on.
To use:
- Add the History function to your project via the Functions tab in the Object Browser
- Bind the Source of the History function properties to the cell where you want to capture the insert history.
- Bind the Destination of the History function to a column range of cells where you want to save the insert history - NOTE: the size of the Destination column will determine how much data history is saved. This can be useful if you are only wanting users to go back so far in their Data Insertion history.
