Automatically fill in third column depending on data in second column
 

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!

Automatically fill in third column depending on data in second col
 

In C1 enter:
=IF(B1="investor","IR","")
and copy down
--
Gary''s Student - gsnu200720


"J.J." wrote:

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!

Automatically fill in third column depending on data in second col
 

This doesn't meet my needs, sorry. Thanks though.


On May 11, 12:08 pm, Gary''s Student
wrote:
In C1 enter:
=IF(B1="investor","IR","")
and copy down
--
Gary''s Student - gsnu200720

"J.J." wrote:
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!