Related Excel tables

Employer
[no-member:pro]Andrey[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsfrom Mar 23, 2022 until Mar 28, 2022
Project description
Offering extra earnings. For several stores, daily unloading from 1c to excel with the remains of goods is carried out. Each product has a unique scu code.
Goods are sorted by the totality of their characteristics, on the basis of these signs, a certain number of places on the shelves is allocated for them.
The task is to create a table that would display the planned number, actual quantity and difference (fact plan) for each group of goods.
Requirements for the table:
The planned amount should be able to change from time to time.
Keep in mind that the table with the remains every day is new
The distribution of goods should be able to change
Goods are sorted by the totality of their characteristics, on the basis of these signs, a certain number of places on the shelves is allocated for them.
The task is to create a table that would display the planned number, actual quantity and difference (fact plan) for each group of goods.
Requirements for the table:
The planned amount should be able to change from time to time.
Keep in mind that the table with the remains every day is new
The distribution of goods should be able to change