Excel - creating a network of linked tables

Closed job
no avatar
BET-SYSTEM
Employer
Job category:
Data processing
Expected budget:

Negotiable

Published:
Finished

Job description

Good day,

I need to create a network of excel tables linked to each other that will organize different types of transactions, e.g. after taking a history from a bank account, flip the value to our "bank" table, then part of the transaction e.g. ATM withdrawal copy automatically to "cash" table, from this table part of the transaction e.g. cash for construction X copy automatically to "construction X" table etc. With all these transactions/expenditures in all tables, I would also like to copy some of these transactions to another summary table e.g. "health and safety" or "equipment", we could capture some transactions by a few key words or by the name of the supplier, and some I would have to mark manually at least by adding an appropriate symbol in an additional column, which would correctly qualify the expense. I think that the total number of such tables could be about 20.

More details to be agreed over the phone.

The job in figures:

20 closely related tables