Macro VBA Excel
Detailed TZ:
The macro process: In file No1 the "Start" sheet will extract the button "Select the SCHOOL REST file" (file format ".ods").File No. 2 .The user clicks on the button, hopes out the file selection window, and the user downloads the book.In the folder added "File No. 2 of the remains of TS".From the file No2 the macro has to make a Pivot (will in the massive, not in the letter) by Article + The number of macro has to clay in the new massive - the massive from p.2.and Articles from the “SITE BAZA” file No1 (this article=model), where status=true.And pick up doubles of items in the second mass.Macro has to create a new Book file No5 (e.g. "LIFE_Terminal Delivery") with columns in the following logic: "No" columns - pass as in the example (so needed) "Articles" columns - here we add the item from the massive p.3 "Terminal Delivery" columns to put the number according to this logic in priority order: A) If [Rest of this item in the file No2 > 0] and [Articles are in the "BAZA" site] -> then the number 0
😎 If [Articles are not in file No2] or [Articles are in file No2 = 0] and [Articles are in the ‘Site BAZA’] -> then the number is taken from the ‘Site BAZA’ by logic as the article begins.
C) If [The name of the file No. 2 contains the word "Books"] and [The article is not in the "SITE BAZA"] -> then [this article falls into the new book "Errors" (file No. 6)] and [this article is not added to the file No. 5 list]
D) If [the name of the file No2 contains the word "Books"] and [the remains of it in the file No2 = 0] and [the article is not in the "site BAZA"] -> then this item is not added to the file No5 list.
E) If the item in file No2 remains negative - then this item falls in the book "Errors" (file No6) Column "Accurate Date" - take it from the list "Terminal" (if it is there) 5.Macro adds the name and residues from the file No2 to the "TOP" sheet (there the user himself inserts the items that he considers TOP)
6 .The macro extracts something like a pivot on the page “THE THREE CODES” where the sum is counted for each TREE CODES from the file No. 2
7 .Macro takes the data from the "OptionsIMPORT" and creates a new file No5 and copies the data there without formulas.If the error is N/A -> then we put 0.8thMacro creates a new folder, where the file No1 is located with the name of today's D.M.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.G.GMacro keeps file No. 1
Applications 6
Client's review of cooperation with Yuriy Troynyak
Macro VBA ExcelI recommend the executive, it’s all great!
Freelancer's review of cooperation with Nikolay Oli
Macro VBA ExcelMacro was quite difficult. One time to get analysis and calculation. But finally, we did it.
-
5920 345 0 I can write a set of macros for Excel to work according to the algorithm.
The algorithm should be discussed because already in the third point it is unclear how you want to combine the massive article + number with the massive model.
The price and deadline will be clear after discussions.
-
1312 37 0 Good day .
The experience of writing macros is.
Ready to start.
-
135 1 0 Good Morning, Miko! I’m ready to do your task, but I’ll take 4 days. If the deadlines are suitable for you with pleasure help.
-
Не проще программу написать? Загнать в неё весь этот функционал, добавить плюшек и спокойно работать?
-
Чим макрос - не програма? 🙂
Сайт та складська система дають екселі. Тому більш зручне для нас рішення - макрос в Екселі
-
Current freelance projects in the category Desktop Apps
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 3 days 12 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
22 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 ∙ 8 days 8 hours back ∙ 23 proposals |
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 ∙ 13 days 16 hours back ∙ 20 proposals |