Project translated automatically. Log in or register, to view the original Recorded a short video description in Loom: https://www.loom.com/share/d355bffc90d24ffb833547717ddca515?sid=12caa069-c62a-498e-8418-d9b4c1cb4b09 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 B) 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

Applications6

View

Proposals 4 Rejected 1 Discussions 2

Anton T.

345 0

Budget: 1234 UAH Deadline: 3 days

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.

Mykola Dudych

37 0

Budget: 4000 UAH Deadline: 7 days

Good day .
The experience of writing macros is.
Ready to start.

Yuriy Troynyak

Winning proposal

1 0

Projects -
Rating -
Rating 135

Budget: 1000 UAH Deadline: 4 days

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.

Nikolay Oli
Kyiv, Ukraine

Projects 7
Rating -
Rating 250

Macro VBA Excel

Client's review of cooperation with Yuriy Troynyak

Macro VBA Excel

5.0

Nikolay Oli

Freelancer's review of cooperation with Nikolay Oli

Macro VBA Excel

5.0

Yuriy Troynyak

Anton T.

Mykola Dudych

Yuriy Troynyak

Proposals concealed

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Desktop Apps

Microsoft Power Platform/Power App

Need a specialist for developing an online store on Shopify with Amazon integration.

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

Small edit on the website