Write the formula for Excel / or remove the program
13 USD 1 .File export of goods from the site
2ndIt is necessary in the "Specials" tab in the "H" column to extract values from the "products" tab and the "E" column, and in the "F" column of the "Specials" tab to extract values from the "products" tab and the "M" column.Connecting values by product ID (it is prescribed in these tabs) (so that the formula searched for the same values by ID in both tabs and in the Specials tab submitted values from the columns I assigned)
ThreeWe combine the second "Rest + Season" file with the original file (by product ID) with the "ProductAttributes" tab, we search for the "Season" (link by product ID) and in the text_ru_ru field we enter the "Rest + Season" value from the "Parent" column.But before this, you need to make this column in order.It should contain values only for the name of the season: Autumn-Winter 2020 (two words by defis + year) .After you bring the column to the fact that there will be only these values, we will write them.4 .We then take (link to the Product ID) the attribute "Sezon" and its values and enter the "Specials" tab in the column "I"
It is important that the bond goes by the product ID, accordingly the attribute of the season must correspond.Write your price.Furthermore, it may be on a quick hand you can write a program that will "shake" two files (they will be the same, unless new goods to the export can be added) and issue one file, with all the necessary content described above?
Сами файлы
Applications 2
Client's review of cooperation with Oleg M.
Write the formula for Excel / or remove the programEverything is great, done quality and quickly.
Freelancer's review of cooperation with Aleksandr Byalkovsky
Write the formula for Excel / or remove the programAlexander put a clear task, checked and paid the job. I recommend cooperation.
-
Winning proposal1 day13 USD
1115 109 0 Winning proposal1 day13 USD
Good day .
I can do both a formula and a macro, depending on a number of points. Write to LS to clarify the details of the project.
-
3 days33 USD
812 15 0 3 days33 USD
I do as you need, in the product file will be the option to select the file to import, that is, two files will be folded, please contact.
-
2 days4 USD
303 4 0 2 days4 USD
Hello to you. There is experience in Excel. Your task is performed by different methods. For convenience, we choose what you need. Ready to discuss the details and begin the work. I will perform in time. thank you.
-
1 day4 USD
421 13 0 1 day4 USD
Hello to you!
I work with Excel and Google tables.
Ready to help with the formula or macro (scripts).
I will be happy to cooperate.
-
3 days45 USD
967 57 0 3 days45 USD
Hello is ready to help you. A lot of experience, I worked with it earlier. The happiness is not very loaded.
-
1 day11 USD
3668 107 0 1 day11 USD
Can you show your Excel files?
This will make it easier to assess the complexity of a formula or script that automatizes your tables.
thank you
-
2 days4 USD
982 30 0 2 days4 USD
Good day ,
I know how to fulfill your task. I know Excel.
Write to Ls we will discuss everything.
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 5 days 7 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 5 days 18 hours back ∙ 6 proposals |
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 ∙ 13 days 8 hours back ∙ 10 proposals |
Odessa