1
Мария
no recommendations
no complaints
Project title: Automation of filling the table in Excel
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Cash, Bank transfer, Electronic money
Acceptance of requests: from 2019-08-20 until 2019-08-27
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Cash, Bank transfer, Electronic money
Acceptance of requests: from 2019-08-20 until 2019-08-27
Project description:
Programmer services are required. Task on automating the filling of the table in Excel.
Example of the table in the attachment. Sheets 1 and 3 are full.
Sheet 2 (Order positions) The following columns must be filled automatically from sheet 3 and 1:
Column 1 - order number from sheet 1 column 6
Columns 2, 3, 6 and 7 must correspond to columns 11, 12, 13 and 14 of sheet 3 of the corresponding order. Orders are tied to an internal number. For example, the number of the first order 319123123 (sheet 1, column 6, line 8), it corresponds to the internal order number 23383 (sheet 1, column 26, line 8). According to this internal number, the table should find this order number in column 1 on the third sheet and enter the articles, the names of goods, their price and quantity in columns 2, 3, 6 and 7 on the second sheet.
IMPORTANT on column 7: in column 27 of sheet 1 is indicated discount customer in percentage. If the cell of the corresponding order is empty, then there is no discount. If there is a figure 5, for example, then the prices from column 14 should be entered on the second page with a 5% discount. See. Example ordered 117123125.
Column 4 should always be filled with the number 0, after the introduction of the goods. Unless it's a delivery.
After listing all the items of the order, the Delivery line always goes with the service code 3 and the number 1. The price is then filled in manually.
After each 2-sheet order, the system must skip the line before filling the content of the next order.
In the end, 2 pages should be filled automatically. The number of orders for 1, 2 and 3 sheets can be any.
Programmer services are required. Task on automating the filling of the table in Excel.
Example of the table in the attachment. Sheets 1 and 3 are full.
Sheet 2 (Order positions) The following columns must be filled automatically from sheet 3 and 1:
Column 1 - order number from sheet 1 column 6
Columns 2, 3, 6 and 7 must correspond to columns 11, 12, 13 and 14 of sheet 3 of the corresponding order. Orders are tied to an internal number. For example, the number of the first order 319123123 (sheet 1, column 6, line 8), it corresponds to the internal order number 23383 (sheet 1, column 26, line 8). According to this internal number, the table should find this order number in column 1 on the third sheet and enter the articles, the names of goods, their price and quantity in columns 2, 3, 6 and 7 on the second sheet.
IMPORTANT on column 7: in column 27 of sheet 1 is indicated discount customer in percentage. If the cell of the corresponding order is empty, then there is no discount. If there is a figure 5, for example, then the prices from column 14 should be entered on the second page with a 5% discount. See. Example ordered 117123125.
Column 4 should always be filled with the number 0, after the introduction of the goods. Unless it's a delivery.
After listing all the items of the order, the Delivery line always goes with the service code 3 and the number 1. The price is then filled in manually.
After each 2-sheet order, the system must skip the line before filling the content of the next order.
In the end, 2 pages should be filled automatically. The number of orders for 1, 2 and 3 sheets can be any.
