Написать макрос для Excel
Здравствуйте
Нужно написать макрос для выполнения следующих операций в Excel:
Формирование характеристик товаров из описания или наименования товара на основе таблиц замен.
По порядку:
1.создаем файлы с таблицами заменами, два столбика то что заменяем и на что заменяем.
2. Открываем рабочий файл таблицу (CSV), создаем пустой столбик с нужной характеристикой Тип (к примеру)
3. В настройка макроса указываем:
- название файла с нужной нам таблицей замен
- указываем столбик таблицы где ищем характеристики
- столбик куда выводим результат
Макрос находит в ячейке вхождение из первого столбика таблицы замен (то что заменяем) и помещает в ячейку напротив в рабочем файле то на что заменяем. Если вхождений несколько разделяем их ",".
Current freelance projects in the category Databases & SQL
Development of Backend core (Python), Telegram FSM engine, and Stripe integrationWe are looking for an experienced Backend Developer (Middle/Senior) to create an independent Headless core for an EdTech product. The system operates on a strict monthly subscription model. The core logic must be completely isolated from the content. All development is conducted… Python, Databases & SQL ∙ 6 hours 1 minute back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 10 hours 57 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 14 hours 29 minutes back ∙ 29 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 23 hours 3 minutes back ∙ 34 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 17 hours back ∙ 16 proposals |
Kharkiv