Search by part of the name

Many years ago I worked for ECOFINANCE company where, at my time, I wrote an Excel invoicing application. It seems to me that it was quite easy to use. Partly because it was enough to enter part of the name of the code or product to find the desired item. The seller would then only select the quantity and packaging and could quickly continue to enter items until the document is completed. Today this can be achieved much easier, without any VBA programming …

Error checking functions

Errors are happening and this is inevitability! When we know in advance that there is a high likelihood that they can happen, we can use error detection functions. They can discover whether an error has occurred, to return its code, and to show an alternative value instead of a mistake. This can be, for example, a notification about a predefined text about an error or an empty cell, if we want to ignore the error …