Another bug cell in the source list - E12 : the department 1 does not trade with a log. How does the Extended Accounting found this erroneous cell? It simply finds available values of Goods column on the Hierh worksheet ( please see above) while the value in the Department column = 1.

Please note that the Extended Accounting can check many columns of this worksheet by this way. For this purpose you will need only to create your own Hierh ( you may use another name) worksheet and define the link to it in the special form.

You can also use the Extended Accounting for the automated data entry on your worksheet. How can the Extended Accounting automate your entry? It is simply. It offers to enter data into all columns of your list. If you enter the wrong value and the Extended Accounting knows that one is not valid, it offers to correct it. What is more, if there is only one valid value, the Extended Accounting enters it automatically. How can the Extended Accounting know the set of valid values for the current cell if this value depends of many other columns? It simply finds the available values of the current column on the Hierh worksheet (or other worksheets) while the values of other controlled columns of this worksheet(s) are the same as in the worksheet you create.