Update Excell Complex Sheet with VBA scripts

Closed job
no avatar
BiznesEkspres
Employer
Job category:
Office works
Expected budget:

Negotiable

Published:
Valid until:

Job description

I have a properly made spreadsheet with the following functionality:

1. loading (VBA script) from structured Excell sheets (about 25 pieces) tables (attachments to subcontractors' invoices with a description of the scope and time of their work and costs incurred in a given month) and saving this data to a normalized table in the master sheet.

2. Based on the table in the master sheet, summary statements of work reported by contractors on a per-project basis (about 20 projects) are generated.

3. Based on the imported data, additional reports are generated on, for example, the budget of a given project and the profitability of the company implementing these projects.

I need to update this tool, which requires a contractor to understand how it works. After that, I will need ongoing support.

The job in figures:

I wrote in the description

Place or location:

remote