We will create an Excel application based on the following simple workbook of payments:
Suppose, we have a team that uses this workbook: Alex as a leader, Nick, and Lora.
In common case, such workbooks are located in shared folders or corporate portals.
Simultaneous editing of such workbooks is not easy.
Also, every user periodically wants to add personal worksheets or formulas and do not share them with others.
We will solve all these issues placing data tables to a database.
Moreover, you can do this yourself. SQL or VBA knowledge is not required.