Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

22 USD

Macro in the Google Customer Order Table.

22 USD

Databases & SQL, Desktop Apps, Web Programming

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

Project translated automatically. Log in or register, to view the original

The main task is to write a macro that would correctly change the quantity of the product issued in the customer's order table.Based on the expenditure list.In the order table 3 lists.1.The “order” list.The customer makes an order.2.List of “Current”.It is required to be processed.3.List of “Template”.When the customer chooses the names in the "Order" table from this list are drawn "Articles" and "Caracteristics" from the corresponding columns.There is a tab "Order" with the fields "Date of Order", "Nomination", "Quantity", "Articles", "Caracteristics", "Date of Delivery".· The fields "Date of Order", "Caracteristics", "Date of Delivery" are filled manually;· The field "Nomination" allows you to select the item from the falling list (sort of goods); · The fields "Articles", "Caracteristics" are filled automatically after selecting the item in the field "Nomination".Information is taken from the "Sample" list (This is to be done)· The table is sorted by the "Date of issuance" field (from the early date to the later) There is a "Call" table with the fields "Name", "Article", "Metery Unit" and "Quantity".The "Call" table is copied and inserted the already existing "Call" with the fields "Name", "Article", "Metery Unit" and "Quantity".It is necessary to write a macro that will reduce the value in the field "Call" table "Call" for the goods with the items that are found in "Call".Important: process the "Order" table from the top to the bottom.Example:In the "Order" table 2 times is the value 141 in the "Article" field 141, the first time number 2, the second time number 3, the total number is equal 5.We enter the "Order" table a line from the already existing "Order" table:The article is the same as in the "Order" table, the number 4, meaning we begin to change the values in the "Order" table in the "Counter" column for goods with the item 141 starting from the top as follows:In the line No3 the value number is equal to 0, in the line No5 is equal to 1, the total number is now 1.Table for examplehttps://docs.google.com/spreadsheets/d/1D_CCEQTh0djY3ZF7c5g0RHW9L2HQqd1btLecy8pyk38/edit?usp=sharing

Client's review of cooperation with Oleg M.

Quality

Professionalism

Cost

Contactability

Deadlines

I did everything in time and quality.

Zahar Pronin | Safe

Freelancer's review of cooperation with Zahar Pronin

Payment

Task setting

Clarity of requirements

Contactability

Everything is good. It was a bit delayed with the deadlines of acceptance of work, but with whom it does not happen. I am pleased and will be happy with the new orders.

Oleg M. | Safe

Proposals 5

by default date online rating cost completion time

Winning proposal22 USD

Oleg M.

109

Winning proposal22 USD

The officer was familiar with the task.
I do everything I need according to the TZ with the details that were discussed in ls.
Duration of 1 to 2 days

Show original

Translate

8 March 2020, 10:36

18 USD

Ilya Kulpin

29 1

18 USD

Good day ! I will perform your task. There is experience in writing such macros. I understand Excel and VBA.

Show original

Translate

7 March 2020, 7:45

111 USD

Aleksey Stasevich

37 1

111 USD

Good day .
Such tasks were scattered like sprinkled nuts.
I suggest to discuss.

Show original

Translate

6 March 2020, 18:48

111 USD

Kseniya Ivanova

56 3

111 USD

Good day . I specialize in such tasks. I propose to discuss more in detail

Show original

Translate

6 March 2020, 17:39

1 proposal concealed

Current freelance projects in the category Databases & SQL

It is necessary to check the scripts and update the data in the Postgres database. It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 5 hours 44 minutes back ∙ 18 proposals
Need an Airtable architect to build a relational schema and a new clean Airtable base. Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 23 hours 3 minutes back ∙ 8 proposals
Basketball Coaching Education Platform + Custom CMS Basketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 1 day 16 hours back ∙ 83 proposals
Integration of Viber in 8.3 223 USD Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 1 day 19 hours back ∙ 13 proposals	223 USD
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning 22 USD Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 3 days 17 hours back ∙ 6 proposals	22 USD

Zahar Pronin

Zhitomir 11 1

Macro in the Google Customer Order Table.

Client's review of cooperation with Oleg M.

Freelancer's review of cooperation with Zahar Pronin

Current freelance projects in the category Databases & SQL

It is necessary to check the scripts and update the data in the Postgres database.

Need an Airtable architect to build a relational schema and a new clean Airtable base.

Basketball Coaching Education Platform + Custom CMS

Integration of Viber in 8.3

Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning