Change Column Value Based on Another Column's Value

[freybe06]

Hello Everyone,

I have some code here that isn't working for some reason and I'm not sure why... Here is the code:

Please Login or Register  to view this content.

I would like the code to take any row that has "JAN" anywhere in column D, and change the value in column J to "January".

Let me know if you need more info.

Thanks!

[judgeh59]

give this a try...I changed the Column for testing....AND this will also change anything that has JAN in it....

Please Login or Register  to view this content.

[freybe06]

Looks Great! Thanks Judge!

[judgeh59]

glad I could help....thanks for the rep points....have a great day