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!

10 USD

Optimization of Excel

10 USD

Desktop Apps

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

Terms of reference in the TK application file 1 The file will be in the public domain 1 Apply the macro to the sheet (PP KR 2018) 2 Optimize (improve the code) of the Worksheet_Change macro located in the source code of the sheet (PP KR 2018) 2.1 if the cell is activated and no changes have occurred, then the data about the cell that changed were updated in the range of columns 537 - 539Example - activated the cell copied part of the text and exited without changeExample - just clicked on the cells 2 times but then changed their minds to change and exitedExample - started editing the text but then changed their minds and exited by pressing ESC3 everything up to 520 column was hidden and 3.1 Column ranges were displayed (date column + 6 columns) highlighted in brown - hereinafter "column range to fill" = DSDZcondition ((3 days minus (date in column 3 cell) plus 3 days) - relative to today's date) 3 days - 01/01/2018 + 3 days ep - the user opens the file on 01/11/2018, then DSDZ is displayed on 01/08/2018 today's DSRS from the previous DSRS (highlighted in green, red and blue) 4.1 At the same time, if in the previous DSRS in the column (work progress fact%) is 100, then the data from the previous DSRS was not copied 4.2 When double-clicked, MSGBOX popped up with the question "Copy previous data" yes no5 In column 131, the greater of the values indicated in the columns (progress of work, fact %) of the range from 134 to 520 (highlighted in purple) was transferred (copied)6 In the range of columns from 522 to 535 Columns 522 and 529 indicated the date from which DSDZ the TK data was transferred There is a certain monitoring file located on the network, the path to this file along with the name will be indicated in the A5 sheet ZAGLAV to the specified address, if an error popped up MSGBOX about a connection error or lack of access rights and the macro execution was completed if the check is successful, then the book opens at the address "no difference for reading or just" and then 2.2 2.2 from the sheet of the indicated book indicated in ZAGLAV, data was copied and pasted into the range 541 549 copying took place only from those columns that will be specified in ZAGLAV 2.3 Copying took place according to a certain algorithm, the search takes place by the value (column number is specified in ZAGLAV) of the column of this book (the range is taken from line 6 to the last filled one) after the cycle is taken, the value after 6 line (I.02.1) and is located in (column number indicated in ZAGLAV ) in a column of a previously opened book at the specified address, after this value is found, the macro copies values from the specified columns from the book and inserts them into this book into the cells of the defined columns again specified in ZAGLAV. each cell of the range, the value is not found after everything is done, the previously opened book closes without saving the macro exits if everything is fine, then by analogy with the algorithm above, it is copied from this book back to the open one from the line indicated in ZAGLAV, and also except for column 546, if the value is not found, then skip the error and go further if the user has selected a certain range and clicked on replace, then to the open book only the range that was copied the user selected after the procedure was completed, the macro saved and closed the workbook

Applications 1

Application viewing is only available registered users.

Client's review of cooperation with Ivan Moroz

Quality

Professionalism

Cost

Contactability

Deadlines

Comprehensive and common! The work is done in the shortest possible time.

Profile deleted | Safe

Freelancer's review of cooperation with client

Payment

Task setting

Clarity of requirements

Contactability

Yuri, gives a fairly clear TZ and explains in detail all its nuances and subtles.
Only positive impressions from cooperation.
I strongly recommend Yuri as a customer!

Ivan Moroz | Safe

Proposals 1

Winning proposal10 USD

Ivan Moroz

Winning proposal10 USD

Hello to you!
I do it quickly and quality.
I am responsible for the task. Always in contact.
Go to turn!

Show original

Translate

17 February 2018, 14:44

Current freelance projects in the category Desktop Apps

Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food) 23 USD We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 4 days 9 hours back ∙ 20 proposals	23 USD
It is necessary to migrate the current working program from FoxPro to C#. Hello everyone! We have a program in FoxPro (it has several modules, it's an accounting program), we have the source code of the program, and if necessary, we can consult with people who support the current program. What needs to be done: 1. Analyze how everything works,… C#, Desktop Apps ∙ 9 days 17 hours back ∙ 19 proposals
About the Master Program "KONSTRUCTOR" 4182 USD We are looking for a very experienced C++ developer to modernize existing software (master program). The program is responsible for creating derivative software representing audio-visual sessions of psychological correction. The current version is written in pure WinAPI (Visual… C & C++, Desktop Apps ∙ 12 days 6 hours back ∙ 20 proposals	4182 USD
ODOO Enterprise setup for construction Необхідно побудувати картки та налаштувати зручний імпорт, інтеграцію з ЕДО і загалом Workflow ODOO Компанія займається системною інтеграцією: маємо поставки обладнання В2В або з прямою маржинальністю, або з рібейтами в подальшому. Крім того, ведемо будівельні роботи на об'єктах… Enterprise Resource Planning (ERP), Desktop Apps ∙ 12 days 15 hours back ∙ 7 proposals

Profile deleted

Optimization of Excel

Client's review of cooperation with Ivan Moroz

Freelancer's review of cooperation with client

Current freelance projects in the category Desktop Apps

Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)

It is necessary to migrate the current working program from FoxPro to C#.

About the Master Program "KONSTRUCTOR"

ODOO Enterprise setup for construction