542473 Excel Macro Search Text and Categorize
N/A
Paid on delivery
Develop a Macro that will look at a CSV file in Excel and do the following:
1. The user will select cells of text in a column , (ex. D2- D420)
2. The Macros will search for a key word, phrase, or series of key words in selected cells
3. If the keyword, phrase, or series of key words is found in the text selection, the Macro assigns a category (ex. "positive") and writes that category in a new cell in the same row where the search was successful. (ex. writes "positive" in cells J2 - J420).
- if the keyword, phrase, or series of key words is NOT found in the text selection, do nothing.
4. the Macro is saved to be able to run on other CSV files in Excel (not embedded in one worksheet only)
This Macro should allow user input as follows:
1. select the cells to be searched
2. input the search keyword, phrase, or series of key words
3. input the category (ex. positive, neutral, or negative)
4. run the macro
5. view the results on the same worksheet
6. have the ability to run the macro again on different cells, keywords, and categories.
Project ID: #2288415