How to put text in same row but different column if a certain text is present in the same row?

Posted by melai on Super User See other posts from Super User or by melai
Published on 2012-09-23T05:58:41Z Indexed on 2012/09/23 9:40 UTC
Read the original article Hit count: 154

Filed under:

How can I put text in the same row but different column if a certain text is present in the same row?

Issue   Area    Correction Done
Process         changed bin
Process         skip lap
        converted to global
Security    done global migration
Process         changed bin

How can I code this in a macro?

For example:

  • If the correction done is in the cell, the Issue should be Process automatically.
  • If the word global is present the Issue should be Security.

I have 500 rows and I want to have the code until row 500.

© Super User or respective owner

Related posts about windows-7