Project translated automatically. Log in or register, to view the original Hello to you.There is such a task: 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?

Update #1 from 16 June 2021

Сами файлы

Proposals 9 Discussions 2

Oleg M.

Winning proposal

109 0

Projects 105
Rating -
Rating 1 115

Budget: 600 UAH Deadline: 1 day

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.

Oleksandr Nazarov

15 0

Budget: 1500 UAH Deadline: 3 days

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.

Sergey Burikov

4 0

Projects 4
Rating -
Rating 303

Budget: 200 UAH Deadline: 2 days

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.