Automatically fill in third column depending on data in second column

J

J.J.

I have a large list of data concerning events that happened in 2004.
Each event is either designated IR or Non-IR. I wish to create a macro
that would allow me to automatically find keywords and automatically
fill in the third column.

For example, if the second column's data has the word "Investor" in
the cell, the third column will automatically populate with the word
"IR"

The way I do it manually is to search the word "investor" and fill in
the data myself in the third column. It's terribly inefficient, and
any help would be great. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I autofill data in a column? 2
Indent and fill color based on other columns data 1
Automatically Populate Worksheet Depending on Team Name 1
Auto-Fill Column based on data in each row 7
Data format issue 2
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet 1
Fill down formula if other column contains data 4
How do I automatically create lists from column topics in a chart 0

Top