Write a macro for Excel table
80 USD ID - is
Description - is a description of the text
Category - Category not assigned, empty cell.
We are planning to break each position by categories using keywords. That is, we get the keyword in search-> all the lines that have such a key are lighted, then in the column with categories the category is attributed.
To save time, we would like to implement such a macro, to assign each line to its category based on the product description.
-
3 days80 USD
647 11 1 3 days80 USDGood day .
I offer a simpler and faster solution.
Create a new list of categories
In the columns with the products to write the formula, time will look for the word in the description and when the match is found, it will write the category in the required columns.
I can get to work immediately.
I will be happy to work together, good evening.
-
1 day80 USD
812 15 0 1 day80 USDI will do what you need, ask me.
• • • • • •
-
1 day80 USD
2870 72 0 1 day80 USDIf there is a list of categories, the macros will do it in seconds.
But we need clarification on the little ones.
For example, the description will fall under several categories - how will it be in that case? These can be drawn into a separate table with all the appropriate categories for additional processing.
If none of the keys did not reach the description... Also a separate list.
You can draw the result on a separate sheet or a new book (it is if there is a desire to leave an untouched source). But that’s little.
Experience with VBA-Excel from 2011.
-
1 day80 USD
759 4 0 1 day80 USDHello to you. that is. on the other list of columns with keywords and we are searching in order for the description. As Valery Makarov wrote above, what to do if the description meets several keys.
-
1 day80 USD
345 22 0 1 day80 USDHello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
2 days80 USD
661 38 2 2 days80 USDWe have extensive experience in creating simple and complex VBA macros for Excel. My profile is description, reviews).
You need to read the file and keys to clarify some questions. For example, which category to assign if the description corresponds to several keys.
-
1 day150 USD
421 13 0 1 day150 USDWelcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
1 day80 USD
1115 109 0 1 day80 USDGood day .
I write a macro on VBA.
You need a file with a small number of lines to test.
-
2 days80 USD
311 21 1 2 days80 USDGood day ! Interested in your project, ready to offer a more interesting implementation than macros in Excel itself. I would like to discuss details.
-
Можете показать пример таблицы.
-
Можно и без макроса обойтись.
Не все любят макросы. )
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 1 day 23 hours back ∙ 15 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 3 days 22 hours 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 ∙ 4 days 9 hours back ∙ 5 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 ∙ 7 days 16 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 9 days 20 hours back ∙ 61 proposals |
Тбилиси