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

XLSX

БАЗА.xlsx

184KB

ODS

ПРИКЛАД файлу №2 залишків ТС.ods

6KB

XLSX

ПРИКЛАД_Exel Dev2studio.xlsx

9KB

XLSX

ПРИКЛАД_Exel Dev2studio (тільки для терміну доставки).xlsx

9KB

XLSX

ПРИКЛАД_помилки.xlsx

9KB

DOCX

тз.docx

17KB

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.