Macro VBA
25 USDIt forms 4 columns of data taken from http://prntscr.com/q7019e, in the end should be obtained.
The first and second columns are the same within one line of the starting table.The "Additional description of the nomenclature" column contains data for the tete and fourth tables. They are between the signs of double transfer. HTTP://prntscr.com/q707r8In one line can be several numbers, they are divided between themselves "/", on the output for each number its lineFor the simplicity of search you need to make a separate sheet with brands (third table), with which the data will be compared if the brand is in the table (http://prntscr.com/q70a1l), then we form a line to the placed. If not, we put the line whole into the cell. And mark with yellow color.
1.Содаеться новый лист
2.В нем формируеться 4 столбца данные беруться из http://prntscr.com/q7019e , в конце должно получиться.
- Первый и второй столбец одинаковые в рамках одной строки исходной таблицы.
- Столбец "Дополнительное описание номенклатуры" содержит данные для тетьего и четвертого столюца. Они находяться между знаками двойного переноса. http://prntscr.com/q707r8
- В одной строке может быть несколько номеров, они разделены между собой "/", на выходе для каждого номера своя строка
- Для простоты поиска нужно сделать отдельный лист с брендами (3й столюец), с которыми будут сравниваться данные, если бренд есть в таблице (http://prntscr.com/q70a1l), то формируем строку ка кположено. Если нету то коируем строку целиком в ячейку. И маркеруем желтім цветом.
Applications 1
Client's feedback on cooperation with Eduard Karpets
Macro VBANot the first time at the height.
Freelancer's feedback on cooperation with Gyulmamedov Iskander
Macro VBAThe experience of parsing sites has been useful in solving this task. As in the previous task, I am pleased with the cooperation and I hope to continue it in the future.
-
581 15 0 Hello, I am interested in your offer.
Experience in writing macros. Ready to do.
Здравствуйте, меня интересует ваше предложение.
Опыт написания макросов есть. Готов сделать.
-
2768 82 2 1 I make a macro. Go to turn.
I make a macro. Go to turn.
I make a macro. Go to turn.
Сделаю макрос. Обращайтесь.
Сделаю макрос. Обращайтесь.
Сделаю макрос. Обращайтесь.
-
1484 55 2 1 Hello, I can write a macro under your task.
= = = = = = = =
Здравствуйте, смогу написать макрос под Вашу задачу
- = - = - = - = -
Current freelance projects in the category Application programming
Optimizing website loading / Google PageSpeed
28 USD
Optimize website loading speed to green zone on all Google PageSpeed metrics for desktop and mobile versions. Web programming, Application programming ∙ 11 proposals |
Automatic dialing program
200 USD
It is necessary to write a program for calling employees of the company. There is an Asterisk server, SIP account, the administrator has allocated 5 lines. The database is stored locally. The operator should form the call database: 1. Full name 2. Position 3. Phone number 4.… IP-telephony and VoIP, Application programming ∙ 1 proposal |
Import products to Simpla website and update themHello, you need to import products through data export. There are different export formats - csv, xml, xls. Also, it is necessary to update the availability of products from a Google spreadsheet. It is required that products with the same SKU from different sources (currently… Web programming, Application programming ∙ 3 proposals |
Develop a smart home on Raspberry.make friends with some touch screen with raspberry When the screen is loaded, there should be 10 pictures and all when you click on the picture with the image of a light bulb, signal 3v one should be when you click on the picture with the image of a kettle, signal 3v another… Application programming |
Set up the feed for exporting goods from Horoshop to KastaSet up a feed for exporting products from an online store on the Horoshop platform to Kasta, according to Kasta's requirements and instructions. 4-5 product categories, up to 50 products per category. Data parsing, Application programming ∙ 2 proposals |