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
Dashboard on Dune AnalyticsStyle reference: dune.com/filarm/polymarket-activity Task To create a neat, visually appealing dashboard on Dune for our bot for Polymarket. At this stage, demonstration (synthetic) data is used — it is generated programmatically but looks logical and plausible, in the style… Databases & SQL ∙ 23 hours 36 minutes back ∙ 11 proposals |
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 18 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 17 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 4 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 11 hours back ∙ 16 proposals |
Тбилиси