Excel - Extracting data from other tables in the right places

Closed job
no avatar
Sara B
Employer
5 deals
Job category:
Data processing
Expected budget:

50.00 PLN

Preferable skills:
excel
Published:
Valid until:

Job description

Creating an Excel that collects data from other places from Excel in the right places and creates a table.

We receive transfers for orders, and excel is to enter the payment for which order is in the appropriate place. The title of the transfer includes either the order number or the e-mail address. From the data, he must extract the appropriate information and complete the order number in the table next to it, and then the data of the person who placed the order.

The job in figures:

Creating formulas that will independently fill the excel table for the data provided to him