Update Excell Complex Sheet with VBA scripts

Employer
no avatar
BiznesEkspres
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.

Published
on 2023-05-12
The job in figures:
I wrote in the description
Place or location:
remote

Offers sent (6)

Kamil
Kamil
24 deals
on 2023-06-02
data analysis
english
excel
+ 2 more
IJON
IJON
6 deals
on 2023-05-12
AI
Airtable
business analysis
+ 14 more
Budget
Negotiable
Copyright
-
Expires in
30 days