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: 161
windows-7
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, theIssue
should beProcess
automatically. - If the word
global
is present theIssue
should beSecurity
.
I have 500 rows and I want to have the code until row 500.
© Super User or respective owner